{
 "cells": [
  {
   "cell_type": "markdown",
   "source": [
    "# 51job有反自动化爬取，半小时能爬取一次"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "outputs": [],
   "source": [
    "import pandas\n",
    "from requests_html import HTMLSession\n",
    "import json\n",
    "import pandas as pd"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1701400617\n"
     ]
    }
   ],
   "source": [
    "import time\n",
    "timestamp = time.time()\n",
    "print(int(timestamp))"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [],
   "source": [
    "cities = {\n",
    "    '上海':'020000',\n",
    "    '北京':'010000',\n",
    "    '广州':'030200',\n",
    "    '深圳':'040000'\n",
    "}"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [],
   "source": [
    "关键字 = input(\"输入职位\")"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "outputs": [],
   "source": [
    "城市 = input(\"输入城市\")"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "outputs": [
    {
     "data": {
      "text/plain": "'010000'"
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cities[城市]"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92\n"
     ]
    }
   ],
   "source": [
    "import urllib.parse\n",
    "encoded_content = urllib.parse.quote(str(关键字))\n",
    "print(encoded_content)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "outputs": [],
   "source": [
    "url = 'https://we.51job.com/api/job/search-pc?api_key=51job&timestamp='+str(int(timestamp))+'&keyword='+str(encoded_content)+'&searchType=2&function=&industry=&jobArea='+cities[城市]+'&jobArea2=&landmark=&metro=&salary=&workYear=&degree=&companyType=&companySize=&jobType=&issueDate=&sortType=0&pageNum=1&requestId=&pageSize=20&source=1&accountId=225393392&pageCode=sou%7Csou%7Csoulb'"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [
    {
     "data": {
      "text/plain": "'https://we.51job.com/api/job/search-pc?api_key=51job&timestamp=1701400617&keyword=%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92&searchType=2&function=&industry=&jobArea=010000&jobArea2=&landmark=&metro=&salary=&workYear=&degree=&companyType=&companySize=&jobType=&issueDate=&sortType=0&pageNum=1&requestId=&pageSize=20&source=1&accountId=225393392&pageCode=sou%7Csou%7Csoulb'"
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "outputs": [],
   "source": [
    "wuyou_job_headers = {\n",
    "    \"Accept\": \"application/json, text/plain, */*\",\n",
    "    \"Accept-Encoding\": \"gzip, deflate, br\",\n",
    "    \"Accept-Language\": \"zh-CN,zh;q=0.9\",\n",
    "    \"Connection\": \"keep-alive\",\n",
    "    \"Cookie\": \"guid=df9079b1bea9db9cb298b4eeb9d04e27; nsearch=jobarea%3D%26%7C%26ord_field%3D%26%7C%26recentSearch0%3D%26%7C%26recentSearch1%3D%26%7C%26recentSearch2%3D%26%7C%26recentSearch3%3D%26%7C%26recentSearch4%3D%26%7C%26collapse_expansion%3D; search=jobarea%7E%60020000%7C%21recentSearch0%7E%60020000%A1%FB%A1%FA000000%A1%FB%A1%FA0000%A1%FB%A1%FA00%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA9%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA0%A1%FB%A1%FA%B9%E3%B8%E6%B2%DF%BB%AE%A1%FB%A1%FA2%A1%FB%A1%FA1%7C%21recentSearch1%7E%60040000%A1%FB%A1%FA000000%A1%FB%A1%FA0000%A1%FB%A1%FA00%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA9%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA0%A1%FB%A1%FA%CF%FA%CA%DB%D6%FA%C0%ED%A1%FB%A1%FA2%A1%FB%A1%FA1%7C%21recentSearch2%7E%60030200%A1%FB%A1%FA000000%A1%FB%A1%FA0000%A1%FB%A1%FA00%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA9%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA0%A1%FB%A1%FA%CF%FA%CA%DB%D6%FA%C0%ED%A1%FB%A1%FA2%A1%FB%A1%FA1%7C%21recentSearch3%7E%60020000%2C030200%A1%FB%A1%FA000000%A1%FB%A1%FA0000%A1%FB%A1%FA00%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA9%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA0%A1%FB%A1%FA%CF%FA%CA%DB%D6%FA%C0%ED%A1%FB%A1%FA2%A1%FB%A1%FA1%7C%21recentSearch4%7E%60020000%A1%FB%A1%FA000000%A1%FB%A1%FA0000%A1%FB%A1%FA00%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA99%A1%FB%A1%FA9%A1%FB%A1%FA99%A1%FB%A1%FA%A1%FB%A1%FA0%A1%FB%A1%FA%CF%FA%CA%DB%D6%FA%C0%ED%A1%FB%A1%FA2%A1%FB%A1%FA1%7C%21; partner=cn_bing_com; seo_refer_info_2023=%7B%22referUrl%22%3A%22https%3A%5C%2F%5C%2Fcn.bing.com%5C%2F%22%2C%22referHost%22%3A%22cn.bing.com%22%2C%22landUrl%22%3A%22%5C%2F%22%2C%22landHost%22%3A%22www.51job.com%22%2C%22partner%22%3Anull%7D; privacy=1701400674; Hm_lvt_1370a11171bd6f2d9b1fe98951541941=1701258507,1701306677,1701400677; slife=lastvisit%3D010000%26%7C%26; Hm_lpvt_1370a11171bd6f2d9b1fe98951541941=1701400682; acw_tc=ac11000117014006894224942e00df9859b48d236cca47fa79a61ddd858e21; NSC_ohjoy-bmjzvo-200-159=ffffffffc3a0d42e45525d5f4f58455e445a4a423660; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%22225393392%22%2C%22first_id%22%3A%2218c1ae8b042878-0ee7352aa1ad44-26031051-1327104-18c1ae8b043557%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E8%87%AA%E7%84%B6%E6%90%9C%E7%B4%A2%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC%22%2C%22%24latest_referrer%22%3A%22https%3A%2F%2Fcn.bing.com%2F%22%7D%2C%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMThjMWFlOGIwNDI4NzgtMGVlNzM1MmFhMWFkNDQtMjYwMzEwNTEtMTMyNzEwNC0xOGMxYWU4YjA0MzU1NyIsIiRpZGVudGl0eV9sb2dpbl9pZCI6IjIyNTM5MzM5MiJ9%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%24identity_login_id%22%2C%22value%22%3A%22225393392%22%7D%2C%22%24device_id%22%3A%2218c1ae8b042878-0ee7352aa1ad44-26031051-1327104-18c1ae8b043557%22%7D; ssxmod_itna=eqGxgDRQG=D=qAK40LyCDUhQ8eR4D5qQwpoewdD/+IDnqD=GFDK40EogKi3e4eoG0Ab4GOUDEB4aGC03gb=qoAfyeDHxY=DUae2PTD4RKGwD0eG+DD4DW4qAoDexGPc0wLKGWD4qDOD3qGy9+=DAS=Dbr=RDiUZDDt7R4G2D7U9YDDll0qK34ePwddKVkbDALABK7DcD0U3xBdYGpDczQ9OoAUBb1aeahjDqeGuDG6VWqGm98bDCE6MilmKWxhKIA5iID4F38DrSiELHYoiexw+074Xxx+aoDm+A7DjXDkDG4x6vHD==; ssxmod_itna2=eqGxgDRQG=D=qAK40LyCDUhQ8eR4D5qQwpoeqG9b5DIOxGXIKiGaKDrUshoULkxki=sxc=jh0sokWTHRwcGSW3jATs4LP28ijb=gisTr9M5KhkdWuxSFnfxAPQ=kxEcGnR6qe4Y72PxHoPA7tpHGCgpNoRhzUBnks=mrWPm8t=OakEqeED07eDqDLxG7eYD=; acw_sc__v2=6569507c64c01bb575ec64856a18f18395544f82\",\n",
    "    \"From-Domain\": \"51job_web\",\n",
    "    \"Host\": \"we.51job.com\",\n",
    "    \"Referer\": \"https://we.51job.com/pc/search?jobArea=010000&keyword=%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92&searchType=2&sortType=0&metro=\",\n",
    "    \"Sec-Fetch-Dest\": \"empty\",\n",
    "    \"Sec-Fetch-Mode\": \"cors\",\n",
    "    \"Sec-Fetch-Site\": \"same-origin\",\n",
    "    \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36\",\n",
    "    \"account-id\": \"225393392\",\n",
    "    \"partner\": \"cn_bing_com\",\n",
    "    \"property\": \"%7B%22partner%22%3A%22cn_bing_com%22%2C%22webId%22%3A2%2C%22fromdomain%22%3A%2251job_web%22%2C%22frompageUrl%22%3A%22https%3A%2F%2Fwe.51job.com%2F%22%2C%22pageUrl%22%3A%22https%3A%2F%2Fwe.51job.com%2Fpc%2Fsearch%3FjobArea%3D010000%26keyword%3D%25E5%25B9%25BF%25E5%2591%258A%25E7%25AD%2596%25E5%2588%2592%26searchType%3D2%26sortType%3D0%26metro%3D%22%2C%22identityType%22%3A%22%22%2C%22userType%22%3A%22%22%2C%22isLogin%22%3A%22%E6%98%AF%22%2C%22accountid%22%3A%22225393392%22%2C%22keywordType%22%3A%22%22%7D\",\n",
    "    \"sec-ch-ua\": \"\\\"Google Chrome\\\";v=\\\"119\\\", \\\"Chromium\\\";v=\\\"119\\\", \\\"Not?A_Brand\\\";v=\\\"24\\\"\",\n",
    "    \"sec-ch-ua-mobile\": \"?0\",\n",
    "    \"sec-ch-ua-platform\": \"\\\"Windows\\\"\",\n",
    "    \"sign\": \"77461fc1eb39f7c012026e1bc4376d0fac90bacd7c7efe6ab5c77b1867c95322\",\n",
    "    \"user-token\": \"40e53e49337309f355d376e582e5be5465672527\",\n",
    "    \"uuid\": \"df9079b1bea9db9cb298b4eeb9d04e27\"\n",
    "}\n"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "# 容易黑号，半小时爬取一次就可"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [
    {
     "data": {
      "text/plain": "{'status': '1',\n 'message': '成功',\n 'resultbody': {'searchType': 2,\n  'engineKeywordType': 0,\n  'requestId': '8ebe5956d317e1cf8886b045a477b982',\n  'job': {'items': [{'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"0\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151690627',\n     'jobType': '0',\n     'jobName': '项目策划专员（2024届秋招-北京）',\n     'jobTags': ['在校生/应届生',\n      '本科',\n      '市场营销',\n      '市场调研',\n      '广告',\n      '方案撰写',\n      '广告营销',\n      '社会化营销',\n      '报告输出',\n      '项目把控',\n      '五险一金',\n      '补充公积金',\n      '交通补贴',\n      '餐饮补贴',\n      '专业培训',\n      '年终奖金',\n      '弹性工作',\n      '定期体检'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '6-9千·13薪',\n     'issueDateString': '2023-11-30 11:11:01',\n     'confirmDateString': '2023-10-30 12:02:28',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '12',\n     'industryType1Str': '广告',\n     'industryType2Str': '广告',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'BmJRPAdiBDw',\n     'companyName': '广东省广告集团',\n     'fullCompanyName': '广东省广告集团股份有限公司',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/1/3/2966/2966_120.gif?636174839832753089',\n     'companyTypeString': '已上市',\n     'companySizeString': '1000-5000人',\n     'companySizeCode': '5',\n     'hrUid': '2734',\n     'hrName': 'Summer',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_006_small.png',\n     'hrPosition': '高级招聘经理',\n     'hrActiveStatusGreen': '当前活跃',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': True,\n     'hrLabels': ['1天内处理简历'],\n     'updateDateTime': '2023-11-01 09:15:06',\n     'lon': '116.473025',\n     'lat': '39.964820',\n     'realDistance': '1651.4',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/151690627.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBmJRPAdiBDw.html',\n     'allowChatOnline': False,\n     'ctmId': 2723,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13826420091',\n     'jobTagsForOrder': ['在校生/应届生',\n      '本科',\n      '市场营销',\n      '市场调研',\n      '广告',\n      '方案撰写',\n      '广告营销',\n      '社会化营销',\n      '报告输出',\n      '项目把控',\n      '五险一金',\n      '补充公积金',\n      '交通补贴',\n      '餐饮补贴',\n      '专业培训',\n      '年终奖金',\n      '弹性工作',\n      '定期体检'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151690627&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%220%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2966'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"1\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151434503',\n     'jobType': '0',\n     'jobName': '电影项目策划',\n     'jobTags': ['1年',\n      '本科',\n      '五险一金',\n      '交通补贴',\n      '餐饮补贴',\n      '绩效奖金',\n      '年终奖金',\n      '定期体检',\n      '专业培训'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '5-8千',\n     'issueDateString': '2023-12-01 04:00:20',\n     'confirmDateString': '2023-11-28 13:44:44',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '49',\n     'industryType2': '',\n     'industryType1Str': '影视/媒体/艺术/文化传播',\n     'industryType2Str': '',\n     'funcType1Code': '4401',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'AmNRPV40UW4GYwZjUDM',\n     'companyName': '幸福蓝海影视文化集团股份有限公司北京广告',\n     'fullCompanyName': '幸福蓝海影视文化集团股份有限公司北京广告分公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '国企',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'hrUid': '2154987',\n     'hrName': '幸福蓝海',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_001_small.png',\n     'hrPosition': '招聘经理',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['简历处理快'],\n     'updateDateTime': '2023-11-28 13:44:44',\n     'lon': '116.413739',\n     'lat': '39.971177',\n     'realDistance': '1651.9',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/151434503.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coAmNRPV40UW4GYwZjUDM.html',\n     'allowChatOnline': False,\n     'ctmId': 1824782,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '18652034597',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '五险一金',\n      '交通补贴',\n      '餐饮补贴',\n      '绩效奖金',\n      '年终奖金',\n      '定期体检',\n      '专业培训'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151434503&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%221%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7891066'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"2\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '149271479',\n     'jobType': '0',\n     'jobName': '广告文案策划',\n     'jobTags': ['无需经验', '大专'],\n     'jobNumString': '',\n     'workAreaCode': '010100',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·东城区',\n     'hrefAreaPinYin': 'beijing-dcq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '东城区',\n      'landMarkString': ''},\n     'provideSalaryString': '6千-1.2万',\n     'issueDateString': '2023-11-27 04:00:18',\n     'confirmDateString': '2023-11-23 14:31:40',\n     'workYear': '10',\n     'workYearString': '无需经验',\n     'degreeString': '大专',\n     'industryType1': '01',\n     'industryType2': '01',\n     'industryType1Str': '计算机软件',\n     'industryType2Str': '计算机软件',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'AGFRPABhBTtWMAdmB2A',\n     'companyName': '固城湖（北京）影视传媒',\n     'fullCompanyName': '固城湖（北京）影视传媒有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_software.png',\n     'companyTypeString': '民营',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'hrUid': '18999485',\n     'hrName': '杨',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_006_small.png',\n     'hrPosition': '财务',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': [],\n     'updateDateTime': '2023-11-23 14:31:40',\n     'lon': '116.440790',\n     'lat': '39.910466',\n     'realDistance': '1645.9',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-dcq/149271479.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coAGFRPABhBTtWMAdmB2A.html',\n     'allowChatOnline': False,\n     'ctmId': 6940063,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13911301824',\n     'jobTagsForOrder': ['无需经验', '大专'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=149271479&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%222%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7920322'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"3\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151359145',\n     'jobType': '0',\n     'jobName': '影视策划',\n     'jobTags': ['1年',\n      '本科',\n      '市场信息',\n      '中文',\n      '编导',\n      '导演',\n      '市场调研分析',\n      '策划案',\n      '戏文',\n      '电视剧',\n      '制片',\n      '剧本修改',\n      '带薪年假',\n      '五险一金',\n      '节日福利',\n      '通讯补贴',\n      '交通补贴',\n      '餐饮补贴'],\n     'jobNumString': '',\n     'workAreaCode': '020000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '上海',\n     'hrefAreaPinYin': 'shanghai',\n     'jobAreaLevelDetail': {'provinceString': '上海',\n      'cityString': '上海',\n      'landMarkString': ''},\n     'provideSalaryString': '1-2万',\n     'issueDateString': '2023-11-30 10:40:20',\n     'confirmDateString': '2023-11-03 16:18:55',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '49',\n     'industryType1Str': '广告',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4401',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'BmIFYFAwADhVNgxqXTo',\n     'companyName': '上海黑开唛广告',\n     'fullCompanyName': '上海黑开唛广告有限公司',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/3/2137/2136652/2136652_120.gif?635700457870697366',\n     'companyTypeString': '民营',\n     'companySizeString': '50-150人',\n     'companySizeCode': '2',\n     'hrUid': '1334291',\n     'hrName': '上海黑开唛广告公司',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_005_small.png',\n     'hrPosition': 'HR',\n     'hrActiveStatusGreen': '当前活跃',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['今日活跃'],\n     'updateDateTime': '2023-11-13 15:09:16',\n     'lon': '121.398526',\n     'lat': '31.215727',\n     'realDistance': '936.8',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': True,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/shanghai/151359145.html?s=sou_sou_soulb&t=0_1&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBmIFYFAwADhVNgxqXTo.html',\n     'allowChatOnline': False,\n     'ctmId': 1135430,\n     'term': '1',\n     'termStr': '兼职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '15001979059',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '市场信息',\n      '中文',\n      '编导',\n      '导演',\n      '市场调研分析',\n      '策划案',\n      '戏文',\n      '电视剧',\n      '制片',\n      '剧本修改',\n      '带薪年假',\n      '五险一金',\n      '节日福利',\n      '通讯补贴',\n      '交通补贴',\n      '餐饮补贴'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151359145&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%223%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2136652'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"4\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '150339612',\n     'jobType': '0',\n     'jobName': '百匠新人-营销策划岗',\n     'jobTags': ['在校生/应届生', '硕士'],\n     'jobNumString': '若干',\n     'workAreaCode': '010600',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·丰台区',\n     'hrefAreaPinYin': 'beijing-ftq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '丰台区',\n      'landMarkString': ''},\n     'provideSalaryString': '7.5千-1.5万',\n     'issueDateString': '2023-12-01 04:00:20',\n     'confirmDateString': '2023-11-30 04:53:24',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '硕士',\n     'industryType1': '26',\n     'industryType2': '',\n     'industryType1Str': '房地产',\n     'industryType2Str': '',\n     'funcType1Code': '1701',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'B2ZRNgNnUW5RMFE2Ujc',\n     'companyName': '华润置地控股',\n     'fullCompanyName': '华润置地控股有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_estate.png',\n     'companyTypeString': '国企',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'updateDateTime': '2023-11-30 04:53:24',\n     'lon': '116.359022',\n     'lat': '39.863589',\n     'realDistance': '1641.1',\n     'isCommunicate': False,\n     'isFromXyx': True,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-ftq/150339612.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2Ujc.html',\n     'allowChatOnline': False,\n     'ctmId': 6405499,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 2,\n     'isRemoteWork': False,\n     'jobTagsForOrder': ['在校生/应届生', '硕士'],\n     'isAllowChat': False,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=150339612&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%224%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7371440'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"5\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151434586',\n     'jobType': '0',\n     'jobName': '电视剧项目策划',\n     'jobTags': ['1年',\n      '本科',\n      '文学',\n      '影视',\n      '戏剧',\n      '创意',\n      '五险一金',\n      '交通补贴',\n      '餐饮补贴',\n      '绩效奖金',\n      '年终奖金',\n      '定期体检',\n      '专业培训'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '5-8千',\n     'issueDateString': '2023-12-01 04:00:20',\n     'confirmDateString': '2023-11-28 13:44:36',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '49',\n     'industryType2': '',\n     'industryType1Str': '影视/媒体/艺术/文化传播',\n     'industryType2Str': '',\n     'funcType1Code': '4401',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'AmNRPV40UW4GYwZjUDM',\n     'companyName': '幸福蓝海影视文化集团股份有限公司北京广告',\n     'fullCompanyName': '幸福蓝海影视文化集团股份有限公司北京广告分公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '国企',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'hrUid': '2154987',\n     'hrName': '幸福蓝海',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_001_small.png',\n     'hrPosition': '招聘经理',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['简历处理快'],\n     'updateDateTime': '2023-11-28 13:44:36',\n     'lon': '116.413739',\n     'lat': '39.971177',\n     'realDistance': '1651.9',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/151434586.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coAmNRPV40UW4GYwZjUDM.html',\n     'allowChatOnline': False,\n     'ctmId': 1824782,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '18652034597',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '文学',\n      '影视',\n      '戏剧',\n      '创意',\n      '五险一金',\n      '交通补贴',\n      '餐饮补贴',\n      '绩效奖金',\n      '年终奖金',\n      '定期体检',\n      '专业培训'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151434586&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%225%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7891066'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"6\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '150164667',\n     'jobType': '0',\n     'jobName': '短视频文案策划',\n     'jobTags': ['1年',\n      '本科',\n      '广告短视频',\n      '广告文案',\n      '文案',\n      '电商文案',\n      '抖音',\n      '品牌调性',\n      '平台调性',\n      '五险一金',\n      '员工旅游',\n      '年终奖金',\n      '绩效奖金'],\n     'jobNumString': '',\n     'workAreaCode': '010000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京',\n     'hrefAreaPinYin': 'beijing',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'landMarkString': ''},\n     'provideSalaryString': '1-1.2万',\n     'issueDateString': '2023-11-27 14:35:02',\n     'confirmDateString': '2023-08-08 15:45:56',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '49',\n     'industryType1Str': '广告',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'BGBXNQJlU2UEaQFhAmI',\n     'companyName': '北京金色沸点广告',\n     'fullCompanyName': '北京金色沸点广告有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '少于50人',\n     'companySizeCode': '1',\n     'hrUid': '1873642',\n     'hrName': '金色沸点',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_002_small.png',\n     'hrPosition': '人事',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'updateDateTime': '2023-10-26 16:53:32',\n     'lon': '116.403874',\n     'lat': '39.914889',\n     'realDistance': '1646.3',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing/150164667.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhAmI.html',\n     'allowChatOnline': False,\n     'ctmId': 1564485,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13911255323',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '广告短视频',\n      '广告文案',\n      '文案',\n      '电商文案',\n      '抖音',\n      '品牌调性',\n      '平台调性',\n      '五险一金',\n      '员工旅游',\n      '年终奖金',\n      '绩效奖金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=150164667&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%226%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2648835'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"7\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151982365',\n     'jobType': '0',\n     'jobName': '影视策划（兼职）',\n     'jobTags': ['1年',\n      '本科',\n      '市场信息',\n      '中文',\n      '编导',\n      '导演',\n      '市场调研分析',\n      '策划案',\n      '戏文',\n      '电视剧',\n      '制片',\n      '剧本修改',\n      '带薪年假',\n      '五险一金',\n      '节日福利',\n      '通讯补贴',\n      '交通补贴',\n      '餐饮补贴'],\n     'jobNumString': '',\n     'workAreaCode': '020000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '上海',\n     'hrefAreaPinYin': 'shanghai',\n     'jobAreaLevelDetail': {'provinceString': '上海',\n      'cityString': '上海',\n      'landMarkString': ''},\n     'provideSalaryString': '6千-1.2万',\n     'issueDateString': '2023-11-30 10:40:20',\n     'confirmDateString': '2023-11-13 15:20:02',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '49',\n     'industryType1Str': '广告',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4401',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'BmIFYFAwADhVNgxqXTo',\n     'companyName': '上海黑开唛广告',\n     'fullCompanyName': '上海黑开唛广告有限公司',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/3/2137/2136652/2136652_120.gif?635700457870697366',\n     'companyTypeString': '民营',\n     'companySizeString': '50-150人',\n     'companySizeCode': '2',\n     'hrUid': '1334291',\n     'hrName': '上海黑开唛广告公司',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_005_small.png',\n     'hrPosition': 'HR',\n     'hrActiveStatusGreen': '当前活跃',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['今日活跃'],\n     'updateDateTime': '2023-11-13 15:22:02',\n     'lon': '121.398526',\n     'lat': '31.215727',\n     'realDistance': '936.8',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': True,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/shanghai/151982365.html?s=sou_sou_soulb&t=0_1&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBmIFYFAwADhVNgxqXTo.html',\n     'allowChatOnline': False,\n     'ctmId': 1135430,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '15001979059',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '市场信息',\n      '中文',\n      '编导',\n      '导演',\n      '市场调研分析',\n      '策划案',\n      '戏文',\n      '电视剧',\n      '制片',\n      '剧本修改',\n      '带薪年假',\n      '五险一金',\n      '节日福利',\n      '通讯补贴',\n      '交通补贴',\n      '餐饮补贴'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151982365&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%227%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2136652'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"8\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '150374576',\n     'jobType': '0',\n     'jobName': '万象生-活动策划岗',\n     'jobTags': ['在校生/应届生', '本科'],\n     'jobNumString': '若干',\n     'workAreaCode': '010000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京',\n     'hrefAreaPinYin': 'beijing',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'landMarkString': ''},\n     'provideSalaryString': '8.4千-1.1万',\n     'issueDateString': '2023-12-01 04:30:55',\n     'confirmDateString': '2023-12-01 04:30:55',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '本科',\n     'industryType1': '26',\n     'industryType2': '',\n     'industryType1Str': '房地产',\n     'industryType2Str': '',\n     'funcType1Code': '1701',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'B2ZRNgNnUW5RMFE2Ujc',\n     'companyName': '华润置地控股',\n     'fullCompanyName': '华润置地控股有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_estate.png',\n     'companyTypeString': '国企',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'updateDateTime': '2023-12-01 04:30:55',\n     'lon': '0.000000',\n     'lat': '0.000000',\n     'isCommunicate': False,\n     'isFromXyx': True,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing/150374576.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2Ujc.html',\n     'allowChatOnline': False,\n     'ctmId': 6405499,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 2,\n     'isRemoteWork': False,\n     'contactAllowed': '',\n     'contactDay': '',\n     'contactTime': '',\n     'jobTagsForOrder': ['在校生/应届生', '本科'],\n     'isAllowChat': False,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=150374576&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%228%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7371440'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"9\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151078104',\n     'jobType': '0',\n     'jobName': '媒介策划执行（2024届秋招-北京）',\n     'jobTags': ['在校生/应届生', '本科'],\n     'jobNumString': '4',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '6-8千',\n     'issueDateString': '2023-10-31 04:00:18',\n     'confirmDateString': '2023-10-27 14:29:23',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '本科',\n     'industryType1': '03',\n     'industryType2': '',\n     'industryType1Str': '金融/投资/证券',\n     'industryType2Str': '',\n     'funcType1Code': '4309',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'AmxTNgVgBDgCYVc0Vjc',\n     'companyName': '广东省广新控股集团',\n     'fullCompanyName': '广东省广新控股集团有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_finance.png',\n     'companyTypeString': '国企',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'updateDateTime': '2023-10-27 14:29:23',\n     'lon': '116.449562',\n     'lat': '39.926373',\n     'realDistance': '1647.5',\n     'isCommunicate': False,\n     'isFromXyx': True,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/151078104.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coAmxTNgVgBDgCYVc0Vjc.html',\n     'allowChatOnline': False,\n     'ctmId': 7179809,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 2,\n     'isRemoteWork': False,\n     'jobTagsForOrder': ['在校生/应届生', '本科'],\n     'isAllowChat': False,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151078104&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%229%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '8162604'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"10\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '150164515',\n     'jobType': '0',\n     'jobName': '短视频策划/编导',\n     'jobTags': ['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金'],\n     'jobNumString': '',\n     'workAreaCode': '010000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京',\n     'hrefAreaPinYin': 'beijing',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'landMarkString': ''},\n     'provideSalaryString': '8千-1.2万',\n     'issueDateString': '2023-11-24 13:06:27',\n     'confirmDateString': '2023-08-08 16:24:23',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '49',\n     'industryType1Str': '广告',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4401',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'BGBXNQJlU2UEaQFhAmI',\n     'companyName': '北京金色沸点广告',\n     'fullCompanyName': '北京金色沸点广告有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '少于50人',\n     'companySizeCode': '1',\n     'hrUid': '1873642',\n     'hrName': '金色沸点',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_002_small.png',\n     'hrPosition': '人事',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'updateDateTime': '2023-10-26 16:53:52',\n     'lon': '116.403874',\n     'lat': '39.914889',\n     'realDistance': '1646.3',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing/150164515.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhAmI.html',\n     'allowChatOnline': False,\n     'ctmId': 1564485,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13911255323',\n     'jobTagsForOrder': ['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=150164515&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2210%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2648835'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"11\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151081284',\n     'jobType': '0',\n     'jobName': '品牌策划',\n     'jobTags': ['在校生/应届生',\n      '本科',\n      '广告学',\n      '传播学',\n      '五险一金',\n      '免费班车',\n      '补充医疗保险',\n      '通讯补贴',\n      '餐饮补贴',\n      '员工旅游',\n      '年终奖金',\n      '绩效奖金',\n      '定期体检',\n      '专业培训'],\n     'jobNumString': '10',\n     'workAreaCode': '011100',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·通州区',\n     'hrefAreaPinYin': 'beijing-tzq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '通州区',\n      'landMarkString': ''},\n     'provideSalaryString': '5.5-8千',\n     'issueDateString': '2023-09-26 04:00:19',\n     'confirmDateString': '2023-09-22 11:42:37',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '本科',\n     'industryType1': '44',\n     'industryType2': '',\n     'industryType1Str': '家具/家电/玩具/礼品',\n     'industryType2Str': '',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '广告学',\n     'major2Str': '传播学',\n     'encCoId': 'UT8CZwVgADhVNAVuUTA',\n     'companyName': '北京闼闼同创工贸',\n     'fullCompanyName': '北京闼闼同创工贸有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_electrical.png',\n     'companyTypeString': '民营',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'updateDateTime': '2023-09-22 11:44:37',\n     'lon': '116.802578',\n     'lat': '39.857340',\n     'realDistance': '1641.6',\n     'isCommunicate': False,\n     'isFromXyx': True,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-tzq/151081284.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coUT8CZwVgADhVNAVuUTA.html',\n     'allowChatOnline': False,\n     'ctmId': 7183879,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 2,\n     'isRemoteWork': False,\n     'jobTagsForOrder': ['在校生/应届生',\n      '本科',\n      '广告学',\n      '传播学',\n      '五险一金',\n      '免费班车',\n      '补充医疗保险',\n      '通讯补贴',\n      '餐饮补贴',\n      '员工旅游',\n      '年终奖金',\n      '绩效奖金',\n      '定期体检',\n      '专业培训'],\n     'isAllowChat': False,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151081284&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2211%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '8166484'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"12\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '152127685',\n     'jobType': '0',\n     'jobName': '品牌策划',\n     'jobTags': ['1年',\n      '本科',\n      '办公软件',\n      '项目管理',\n      '营销',\n      '品牌推广',\n      '广告',\n      '项目策划',\n      '报告撰写',\n      '品牌定位',\n      '策划',\n      '周末双休',\n      '专业培训',\n      '弹性工作',\n      '央企机会',\n      '五险一金',\n      '补充医疗保险',\n      '通讯补贴',\n      '餐饮补贴',\n      '交通补贴',\n      '年终奖金'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '7千-1万',\n     'issueDateString': '2023-11-25 04:00:20',\n     'confirmDateString': '2023-11-21 13:24:38',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '49',\n     'industryType2': '17',\n     'industryType1Str': '影视/媒体/艺术/文化传播',\n     'industryType2Str': '娱乐/休闲/体育',\n     'funcType1Code': '0306',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'UjZcOlU1DzUOaQJhUTI',\n     'companyName': '保利影业投资',\n     'fullCompanyName': '保利影业投资有限公司',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/3/2235/2234206/87856423481082926490_300.png?1664419366617',\n     'companyTypeString': '国企',\n     'companySizeString': '150-500人',\n     'companySizeCode': '3',\n     'hrUid': '18542717',\n     'hrName': '保利文娱科技HR',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_006_small.png',\n     'hrPosition': 'HR',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': [],\n     'updateDateTime': '2023-11-21 13:26:38',\n     'lon': '116.506356',\n     'lat': '39.997661',\n     'realDistance': '1654.7',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/152127685.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coUjZcOlU1DzUOaQJhUTI.html',\n     'allowChatOnline': False,\n     'ctmId': 1195807,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '15810483752',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '办公软件',\n      '项目管理',\n      '营销',\n      '品牌推广',\n      '广告',\n      '项目策划',\n      '报告撰写',\n      '品牌定位',\n      '策划',\n      '周末双休',\n      '专业培训',\n      '弹性工作',\n      '央企机会',\n      '五险一金',\n      '补充医疗保险',\n      '通讯补贴',\n      '餐饮补贴',\n      '交通补贴',\n      '年终奖金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=152127685&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2212%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2234206'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"13\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '137789041',\n     'jobType': '0',\n     'jobName': '撰稿策划',\n     'jobTags': ['1年', '大专', '五险一金'],\n     'jobNumString': '',\n     'workAreaCode': '010800',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·海淀区',\n     'hrefAreaPinYin': 'beijing-hdq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '海淀区',\n      'landMarkString': ''},\n     'provideSalaryString': '8千-1.5万',\n     'issueDateString': '2023-11-30 11:48:05',\n     'confirmDateString': '2023-07-14 10:34:53',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '大专',\n     'industryType1': '12',\n     'industryType2': '48',\n     'industryType1Str': '广告',\n     'industryType2Str': '公关/市场推广/会展',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'VjZTP141U25UMFAw',\n     'companyName': '北京创意支点广告',\n     'fullCompanyName': '北京创意支点广告有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '少于50人',\n     'companySizeCode': '1',\n     'hrUid': '508042',\n     'hrName': 'admin',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_006_small.png',\n     'hrPosition': '人事招聘',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': [],\n     'updateDateTime': '2023-07-18 10:00:45',\n     'lon': '116.318550',\n     'lat': '40.041318',\n     'realDistance': '1658.8',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-hdq/137789041.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coVjZTP141U25UMFAw.html',\n     'allowChatOnline': False,\n     'ctmId': 607528,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13391615076',\n     'jobTagsForOrder': ['1年', '大专', '五险一金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=137789041&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2213%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '688313'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"14\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '132202501',\n     'jobType': '0',\n     'jobName': '创意文案策划',\n     'jobTags': ['1年',\n      '本科',\n      '传播学',\n      '跨媒体艺术',\n      '策划',\n      '文案',\n      '新媒体',\n      '餐饮补贴',\n      '五险一金',\n      '补充医疗保险',\n      '补充公积金',\n      '绩效奖金'],\n     'jobNumString': '',\n     'workAreaCode': '010600',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·丰台区',\n     'hrefAreaPinYin': 'beijing-ftq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '丰台区',\n      'landMarkString': ''},\n     'provideSalaryString': '9千-1.2万',\n     'issueDateString': '2023-11-30 12:53:39',\n     'confirmDateString': '2023-11-06 16:57:02',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '48',\n     'industryType1Str': '广告',\n     'industryType2Str': '公关/市场推广/会展',\n     'funcType1Code': '4207',\n     'funcType2Code': '',\n     'major1Str': '传播学',\n     'major2Str': '跨媒体艺术',\n     'encCoId': 'BGRQNV40VmkCZwZiUj4',\n     'companyName': '北京天策行品牌顾问',\n     'fullCompanyName': '北京天策行品牌顾问有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '少于50人',\n     'companySizeCode': '1',\n     'hrUid': '12929536',\n     'hrName': 'tcxv7967',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_006_small.png',\n     'hrPosition': '总经理',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['简历处理快'],\n     'updateDateTime': '2023-11-06 16:57:02',\n     'lon': '116.374719',\n     'lat': '39.860743',\n     'realDistance': '1640.8',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-ftq/132202501.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBGRQNV40VmkCZwZiUj4.html',\n     'allowChatOnline': False,\n     'ctmId': 5077463,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13901371875',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '传播学',\n      '跨媒体艺术',\n      '策划',\n      '文案',\n      '新媒体',\n      '餐饮补贴',\n      '五险一金',\n      '补充医疗保险',\n      '补充公积金',\n      '绩效奖金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=132202501&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2214%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '6191079'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"15\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '147183336',\n     'jobType': '0',\n     'jobName': '客户执行/AE（北京）',\n     'jobTags': ['在校生/应届生',\n      '大专',\n      '广告',\n      '公关',\n      '媒体',\n      '五险一金',\n      '餐饮补贴',\n      '年终奖金',\n      '定期体检'],\n     'jobNumString': '若干',\n     'workAreaCode': '010000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京',\n     'hrefAreaPinYin': 'beijing',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'landMarkString': ''},\n     'provideSalaryString': '6-8千·13薪',\n     'issueDateString': '2023-12-01 04:41:23',\n     'confirmDateString': '2023-12-01 04:41:23',\n     'workYear': '1',\n     'workYearString': '在校生/应届生',\n     'degreeString': '大专',\n     'industryType1': '58',\n     'industryType2': '',\n     'industryType1Str': '多元化业务集团公司',\n     'industryType2Str': '',\n     'funcType1Code': '4219',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'CGlcP1IxVGgFY1Q1UTw',\n     'companyName': '北京天下秀广告',\n     'fullCompanyName': '北京天下秀广告有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/new/home_logo_default_pluralistic.png',\n     'companyTypeString': '民营',\n     'companySizeString': '',\n     'companySizeCode': '',\n     'updateDateTime': '2023-12-01 04:41:23',\n     'lon': '0.000000',\n     'lat': '0.000000',\n     'isCommunicate': False,\n     'isFromXyx': True,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing/147183336.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coCGlcP1IxVGgFY1Q1UTw.html',\n     'allowChatOnline': False,\n     'ctmId': 6648365,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 2,\n     'isRemoteWork': False,\n     'contactAllowed': '',\n     'contactDay': '',\n     'contactTime': '',\n     'jobTagsForOrder': ['在校生/应届生',\n      '大专',\n      '广告',\n      '公关',\n      '媒体',\n      '五险一金',\n      '餐饮补贴',\n      '年终奖金',\n      '定期体检'],\n     'isAllowChat': False,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=147183336&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2215%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7702328'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"16\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '149118726',\n     'jobType': '0',\n     'jobName': '广告客户经理',\n     'jobTags': ['1年',\n      '本科',\n      '广告',\n      '营销',\n      '传媒',\n      '互联网',\n      '销售',\n      '客户经理',\n      '业务员',\n      '销售经理',\n      '大客户广告',\n      '财经媒体',\n      '五险一金',\n      '定期体检',\n      '绩效奖金',\n      '年终奖金',\n      '通讯补贴',\n      '专业培训',\n      '交通补贴'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': 'CBD'},\n     'provideSalaryString': '2-4万',\n     'issueDateString': '2023-11-21 15:40:27',\n     'confirmDateString': '2023-06-08 17:07:54',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '01',\n     'industryType2': '49',\n     'industryType1Str': '计算机软件',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4202',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'A2JWOwNgUm8CYwVjBmQ',\n     'companyName': '上海阿牛信息科技',\n     'fullCompanyName': '上海阿牛信息科技有限公司',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/8/7904/7903457/317670994402445268379_300.png?1686214447142',\n     'companyTypeString': '民营',\n     'companySizeString': '150-500人',\n     'companySizeCode': '3',\n     'hrUid': '18980072',\n     'hrName': '凌女士',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/19/18981/18980072/1686214172132_small.png?1686214173',\n     'hrPosition': 'HR',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'updateDateTime': '2023-07-06 15:50:13',\n     'lon': '116.459632',\n     'lat': '39.909902',\n     'realDistance': '1645.9',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/149118726.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coA2JWOwNgUm8CYwVjBmQ.html',\n     'allowChatOnline': False,\n     'ctmId': 6923379,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '1',\n     'landmarkString': 'CBD',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '15221378424',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '广告',\n      '营销',\n      '传媒',\n      '互联网',\n      '销售',\n      '客户经理',\n      '业务员',\n      '销售经理',\n      '大客户广告',\n      '财经媒体',\n      '五险一金',\n      '定期体检',\n      '绩效奖金',\n      '年终奖金',\n      '通讯补贴',\n      '专业培训',\n      '交通补贴'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=149118726&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2216%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '7903457'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"17\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '151734889',\n     'jobType': '0',\n     'jobName': '票据录入文员',\n     'jobTags': ['无需经验',\n      '大专',\n      '数据统计',\n      '统计报表',\n      '校对',\n      '节日福利',\n      '社保',\n      '绩效奖金',\n      '弹性工作',\n      '专业培训',\n      '员工旅游',\n      '五险一金'],\n     'jobNumString': '',\n     'workAreaCode': '010500',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·朝阳区',\n     'hrefAreaPinYin': 'beijing-cyq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '朝阳区',\n      'landMarkString': ''},\n     'provideSalaryString': '4-5千',\n     'issueDateString': '2023-11-20 10:21:12',\n     'confirmDateString': '2023-10-30 17:42:26',\n     'workYear': '10',\n     'workYearString': '无需经验',\n     'degreeString': '大专',\n     'industryType1': '12',\n     'industryType2': '12',\n     'industryType1Str': '广告',\n     'industryType2Str': '广告',\n     'funcType1Code': '0422',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'VDBSP1QyAzQFZQxsAGU',\n     'companyName': '成都上品集创广告策划',\n     'fullCompanyName': '成都上品集创广告策划有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '50-150人',\n     'companySizeCode': '2',\n     'hrUid': '17841190',\n     'hrName': '罗女士',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_005_small.png',\n     'hrPosition': 'HR',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'updateDateTime': '2023-10-31 09:49:37',\n     'lon': '116.508383',\n     'lat': '39.900119',\n     'realDistance': '1645.0',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': False,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-cyq/151734889.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coVDBSP1QyAzQFZQxsAGU.html',\n     'allowChatOnline': False,\n     'ctmId': 1865233,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13890583252',\n     'jobTagsForOrder': ['无需经验',\n      '大专',\n      '数据统计',\n      '统计报表',\n      '校对',\n      '节日福利',\n      '社保',\n      '绩效奖金',\n      '弹性工作',\n      '专业培训',\n      '员工旅游',\n      '五险一金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=151734889&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2217%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '2959530'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"18\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '133687600',\n     'jobType': '0',\n     'jobName': '品牌策划经理',\n     'jobTags': ['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金'],\n     'jobNumString': '',\n     'workAreaCode': '010600',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京·丰台区',\n     'hrefAreaPinYin': 'beijing-ftq',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'districtString': '丰台区',\n      'landMarkString': ''},\n     'provideSalaryString': '1-1.5万',\n     'issueDateString': '2023-11-30 12:53:37',\n     'confirmDateString': '2023-11-06 16:56:36',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '12',\n     'industryType2': '48',\n     'industryType1Str': '广告',\n     'industryType2Str': '公关/市场推广/会展',\n     'funcType1Code': '0336',\n     'funcType2Code': '',\n     'major1Str': '市场营销',\n     'major2Str': '商务管理',\n     'encCoId': 'BGRQNV40VmkCZwZiUj4',\n     'companyName': '北京天策行品牌顾问',\n     'fullCompanyName': '北京天策行品牌顾问有限公司',\n     'companyLogo': 'https://img04.51jobcdn.com/im/mkt/app/51job_phone/app/homelogo/home_logo_default.png',\n     'companyTypeString': '民营',\n     'companySizeString': '少于50人',\n     'companySizeCode': '1',\n     'hrUid': '12929536',\n     'hrName': 'tcxv7967',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_male_006_small.png',\n     'hrPosition': '总经理',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['简历处理快'],\n     'updateDateTime': '2023-11-06 16:56:36',\n     'lon': '116.374664',\n     'lat': '39.860695',\n     'realDistance': '1640.8',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing-ftq/133687600.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coBGRQNV40VmkCZwZiUj4.html',\n     'allowChatOnline': False,\n     'ctmId': 5077463,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '',\n     'landmarkString': '',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13901371875',\n     'jobTagsForOrder': ['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=133687600&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2218%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '6191079'},\n    {'property': '{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\",\"shortPageCode\":\"sou|sou|soulb\",\"searchType\":\"手动搜索职位\",\"jobRank\":\"19\",\"policyId\":\"{\\\\\"layer_rank_v19\\\\\":\\\\\"1701_0\\\\\",\\\\\"layer_rank_v21\\\\\":\\\\\"1708_1\\\\\"}\",\"keyword\":\"广告策划\",\"pageNum\":\"1\",\"requestId\":\"8ebe5956d317e1cf8886b045a477b982\",\"jobType\":\"0\"}',\n     'jobId': '117352119',\n     'jobType': '0',\n     'jobName': '活动策划执行',\n     'jobTags': ['1年',\n      '本科',\n      '五险一金',\n      '周末双休',\n      '弹性工作',\n      '带薪年假',\n      '绩效奖金',\n      '节日福利',\n      '餐饮补贴',\n      '通讯补贴',\n      '高温补贴',\n      '体检补贴'],\n     'jobNumString': '',\n     'workAreaCode': '010000',\n     'jobAreaCode': '010000',\n     'jobAreaString': '北京',\n     'hrefAreaPinYin': 'beijing',\n     'jobAreaLevelDetail': {'provinceString': '北京',\n      'cityString': '北京',\n      'landMarkString': '崇文门'},\n     'provideSalaryString': '6-9千',\n     'issueDateString': '2023-10-30 15:47:01',\n     'confirmDateString': '2023-09-12 16:20:45',\n     'workYear': '3',\n     'workYearString': '1年',\n     'degreeString': '本科',\n     'industryType1': '32',\n     'industryType2': '49',\n     'industryType1Str': '互联网/电子商务',\n     'industryType2Str': '影视/媒体/艺术/文化传播',\n     'funcType1Code': '4313',\n     'funcType2Code': '',\n     'major1Str': '',\n     'major2Str': '',\n     'encCoId': 'AmcGZlM5DzgPY1QzBWQ',\n     'companyName': '中国家电网',\n     'fullCompanyName': '中国家电网',\n     'companyLogo': 'https://img01.51jobcdn.com/fansImg/CompLogo/4/3500/3499944/3499944_300.png?636554097658104111',\n     'companyTypeString': '国企',\n     'companySizeString': '50-150人',\n     'companySizeCode': '2',\n     'hrUid': '2763858',\n     'hrName': '中国家电网',\n     'smallHrLogoUrl': 'http://img01.51jobcdn.com/imehire/userportrait/default/li_portrait_female_006_small.png',\n     'hrPosition': '人事主管',\n     'hrMedalTitle': '',\n     'hrMedalLevel': '',\n     'showHrMedalTitle': True,\n     'hrIsOnline': False,\n     'hrLabels': ['1天内处理简历'],\n     'updateDateTime': '2023-11-07 16:34:33',\n     'lon': '116.435167',\n     'lat': '39.898915',\n     'realDistance': '1644.7',\n     'isCommunicate': False,\n     'isFromXyx': False,\n     'isIntern': False,\n     'isModelEmployer': False,\n     'isQuickFeedback': True,\n     'isPromotion': False,\n     'isApply': False,\n     'isExpire': False,\n     'jobHref': 'https://jobs.51job.com/beijing/117352119.html?s=sou_sou_soulb&t=0_0&req=8ebe5956d317e1cf8886b045a477b982',\n     'companyHref': 'https://jobs.51job.com/all/coAmcGZlM5DzgPY1QzBWQ.html',\n     'allowChatOnline': False,\n     'ctmId': 2400767,\n     'term': '0',\n     'termStr': '全职',\n     'landmarkId': '6',\n     'landmarkString': '崇文门',\n     'retrieverName': 'JobTermBasedRetriever',\n     'exrInfo02': '{\"retrieverName\":\"JobTermBasedRetriever\",\"referJobId\":\"\"}',\n     'hrInfoType': 0,\n     'isRemoteWork': False,\n     'mobileTel': '13811377345',\n     'jobTagsForOrder': ['1年',\n      '本科',\n      '五险一金',\n      '周末双休',\n      '弹性工作',\n      '带薪年假',\n      '绩效奖金',\n      '节日福利',\n      '餐饮补贴',\n      '通讯补贴',\n      '高温补贴',\n      '体检补贴'],\n     'isAllowChat': True,\n     'jobScheme': 'qiancheng://home/show_job_info?jobid=117352119&property=%7B%22isInitiative%22%3A%22%E6%98%AF%22%2C%22pageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22shortPageCode%22%3A%22sou%7Csou%7Csoulb%22%2C%22searchType%22%3A%22%E6%89%8B%E5%8A%A8%E6%90%9C%E7%B4%A2%E8%81%8C%E4%BD%8D%22%2C%22jobRank%22%3A%2219%22%2C%22policyId%22%3A%22%7B%5C%22layer_rank_v19%5C%22%3A%5C%221701_0%5C%22%2C%5C%22layer_rank_v21%5C%22%3A%5C%221708_1%5C%22%7D%22%2C%22keyword%22%3A%22%E5%B9%BF%E5%91%8A%E7%AD%96%E5%88%92%22%2C%22pageNum%22%3A%221%22%2C%22requestId%22%3A%228ebe5956d317e1cf8886b045a477b982%22%2C%22jobType%22%3A%220%22%7D',\n     'coId': '3499944'}],\n   'totalCount': 208,\n   'requestId': '8ebe5956d317e1cf8886b045a477b982',\n   'policies': '{\"layer_rank_v19\":\"1701_0\",\"layer_rank_v21\":\"1708_1\"}',\n   'totalcount': 208}}}"
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "session = HTMLSession()\n",
    "\n",
    "r = session.get(url,headers=wuyou_job_headers)\n",
    "\n",
    "response_data = r.json()\n",
    "\n",
    "response_data"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "outputs": [
    {
     "data": {
      "text/plain": "                                             property      jobId jobType  \\\n0   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151690627       0   \n1   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151434503       0   \n2   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  149271479       0   \n3   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151359145       0   \n4   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150339612       0   \n5   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151434586       0   \n6   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150164667       0   \n7   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151982365       0   \n8   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150374576       0   \n9   {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151078104       0   \n10  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150164515       0   \n11  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151081284       0   \n12  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  152127685       0   \n13  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  137789041       0   \n14  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  132202501       0   \n15  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  147183336       0   \n16  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  149118726       0   \n17  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151734889       0   \n18  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  133687600       0   \n19  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  117352119       0   \n\n               jobName                                            jobTags  \\\n0   项目策划专员（2024届秋招-北京）  [在校生/应届生, 本科, 市场营销, 市场调研, 广告, 方案撰写, 广告营销, 社会化营...   \n1               电影项目策划  [1年, 本科, 五险一金, 交通补贴, 餐饮补贴, 绩效奖金, 年终奖金, 定期体检, 专...   \n2               广告文案策划                                         [无需经验, 大专]   \n3                 影视策划  [1年, 本科, 市场信息, 中文, 编导, 导演, 市场调研分析, 策划案, 戏文, 电视...   \n4           百匠新人-营销策划岗                                      [在校生/应届生, 硕士]   \n5              电视剧项目策划  [1年, 本科, 文学, 影视, 戏剧, 创意, 五险一金, 交通补贴, 餐饮补贴, 绩效奖...   \n6              短视频文案策划  [1年, 本科, 广告短视频, 广告文案, 文案, 电商文案, 抖音, 品牌调性, 平台调性...   \n7             影视策划（兼职）  [1年, 本科, 市场信息, 中文, 编导, 导演, 市场调研分析, 策划案, 戏文, 电视...   \n8            万象生-活动策划岗                                      [在校生/应届生, 本科]   \n9   媒介策划执行（2024届秋招-北京）                                      [在校生/应届生, 本科]   \n10            短视频策划/编导                   [1年, 本科, 五险一金, 员工旅游, 年终奖金, 绩效奖金]   \n11                品牌策划  [在校生/应届生, 本科, 广告学, 传播学, 五险一金, 免费班车, 补充医疗保险, 通讯...   \n12                品牌策划  [1年, 本科, 办公软件, 项目管理, 营销, 品牌推广, 广告, 项目策划, 报告撰写,...   \n13                撰稿策划                                     [1年, 大专, 五险一金]   \n14              创意文案策划  [1年, 本科, 传播学, 跨媒体艺术, 策划, 文案, 新媒体, 餐饮补贴, 五险一金, ...   \n15         客户执行/AE（北京）  [在校生/应届生, 大专, 广告, 公关, 媒体, 五险一金, 餐饮补贴, 年终奖金, 定期体检]   \n16              广告客户经理  [1年, 本科, 广告, 营销, 传媒, 互联网, 销售, 客户经理, 业务员, 销售经理,...   \n17              票据录入文员  [无需经验, 大专, 数据统计, 统计报表, 校对, 节日福利, 社保, 绩效奖金, 弹性工...   \n18              品牌策划经理                   [1年, 本科, 市场营销, 商务管理, 五险一金, 绩效奖金]   \n19              活动策划执行  [1年, 本科, 五险一金, 周末双休, 弹性工作, 带薪年假, 绩效奖金, 节日福利, 餐...   \n\n   jobNumString workAreaCode jobAreaCode jobAreaString hrefAreaPinYin  ...  \\\n0                     010500      010000        北京·朝阳区    beijing-cyq  ...   \n1                     010500      010000        北京·朝阳区    beijing-cyq  ...   \n2                     010100      010000        北京·东城区    beijing-dcq  ...   \n3                     020000      010000            上海       shanghai  ...   \n4            若干       010600      010000        北京·丰台区    beijing-ftq  ...   \n5                     010500      010000        北京·朝阳区    beijing-cyq  ...   \n6                     010000      010000            北京        beijing  ...   \n7                     020000      010000            上海       shanghai  ...   \n8            若干       010000      010000            北京        beijing  ...   \n9             4       010500      010000        北京·朝阳区    beijing-cyq  ...   \n10                    010000      010000            北京        beijing  ...   \n11           10       011100      010000        北京·通州区    beijing-tzq  ...   \n12                    010500      010000        北京·朝阳区    beijing-cyq  ...   \n13                    010800      010000        北京·海淀区    beijing-hdq  ...   \n14                    010600      010000        北京·丰台区    beijing-ftq  ...   \n15           若干       010000      010000            北京        beijing  ...   \n16                    010500      010000        北京·朝阳区    beijing-cyq  ...   \n17                    010500      010000        北京·朝阳区    beijing-cyq  ...   \n18                    010600      010000        北京·丰台区    beijing-ftq  ...   \n19                    010000      010000            北京        beijing  ...   \n\n   isAllowChat                                          jobScheme     coId  \\\n0         True  qiancheng://home/show_job_info?jobid=151690627...     2966   \n1         True  qiancheng://home/show_job_info?jobid=151434503...  7891066   \n2         True  qiancheng://home/show_job_info?jobid=149271479...  7920322   \n3         True  qiancheng://home/show_job_info?jobid=151359145...  2136652   \n4        False  qiancheng://home/show_job_info?jobid=150339612...  7371440   \n5         True  qiancheng://home/show_job_info?jobid=151434586...  7891066   \n6         True  qiancheng://home/show_job_info?jobid=150164667...  2648835   \n7         True  qiancheng://home/show_job_info?jobid=151982365...  2136652   \n8        False  qiancheng://home/show_job_info?jobid=150374576...  7371440   \n9        False  qiancheng://home/show_job_info?jobid=151078104...  8162604   \n10        True  qiancheng://home/show_job_info?jobid=150164515...  2648835   \n11       False  qiancheng://home/show_job_info?jobid=151081284...  8166484   \n12        True  qiancheng://home/show_job_info?jobid=152127685...  2234206   \n13        True  qiancheng://home/show_job_info?jobid=137789041...   688313   \n14        True  qiancheng://home/show_job_info?jobid=132202501...  6191079   \n15       False  qiancheng://home/show_job_info?jobid=147183336...  7702328   \n16        True  qiancheng://home/show_job_info?jobid=149118726...  7903457   \n17        True  qiancheng://home/show_job_info?jobid=151734889...  2959530   \n18        True  qiancheng://home/show_job_info?jobid=133687600...  6191079   \n19        True  qiancheng://home/show_job_info?jobid=117352119...  3499944   \n\n   jobAreaLevelDetail.provinceString jobAreaLevelDetail.cityString  \\\n0                                 北京                            北京   \n1                                 北京                            北京   \n2                                 北京                            北京   \n3                                 上海                            上海   \n4                                 北京                            北京   \n5                                 北京                            北京   \n6                                 北京                            北京   \n7                                 上海                            上海   \n8                                 北京                            北京   \n9                                 北京                            北京   \n10                                北京                            北京   \n11                                北京                            北京   \n12                                北京                            北京   \n13                                北京                            北京   \n14                                北京                            北京   \n15                                北京                            北京   \n16                                北京                            北京   \n17                                北京                            北京   \n18                                北京                            北京   \n19                                北京                            北京   \n\n   jobAreaLevelDetail.districtString jobAreaLevelDetail.landMarkString  \\\n0                                朝阳区                                     \n1                                朝阳区                                     \n2                                东城区                                     \n3                                NaN                                     \n4                                丰台区                                     \n5                                朝阳区                                     \n6                                NaN                                     \n7                                NaN                                     \n8                                NaN                                     \n9                                朝阳区                                     \n10                               NaN                                     \n11                               通州区                                     \n12                               朝阳区                                     \n13                               海淀区                                     \n14                               丰台区                                     \n15                               NaN                                     \n16                               朝阳区                               CBD   \n17                               朝阳区                                     \n18                               丰台区                                     \n19                               NaN                               崇文门   \n\n   contactAllowed contactDay contactTime  \n0             NaN        NaN         NaN  \n1             NaN        NaN         NaN  \n2             NaN        NaN         NaN  \n3             NaN        NaN         NaN  \n4             NaN        NaN         NaN  \n5             NaN        NaN         NaN  \n6             NaN        NaN         NaN  \n7             NaN        NaN         NaN  \n8                                         \n9             NaN        NaN         NaN  \n10            NaN        NaN         NaN  \n11            NaN        NaN         NaN  \n12            NaN        NaN         NaN  \n13            NaN        NaN         NaN  \n14            NaN        NaN         NaN  \n15                                        \n16            NaN        NaN         NaN  \n17            NaN        NaN         NaN  \n18            NaN        NaN         NaN  \n19            NaN        NaN         NaN  \n\n[20 rows x 77 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>property</th>\n      <th>jobId</th>\n      <th>jobType</th>\n      <th>jobName</th>\n      <th>jobTags</th>\n      <th>jobNumString</th>\n      <th>workAreaCode</th>\n      <th>jobAreaCode</th>\n      <th>jobAreaString</th>\n      <th>hrefAreaPinYin</th>\n      <th>...</th>\n      <th>isAllowChat</th>\n      <th>jobScheme</th>\n      <th>coId</th>\n      <th>jobAreaLevelDetail.provinceString</th>\n      <th>jobAreaLevelDetail.cityString</th>\n      <th>jobAreaLevelDetail.districtString</th>\n      <th>jobAreaLevelDetail.landMarkString</th>\n      <th>contactAllowed</th>\n      <th>contactDay</th>\n      <th>contactTime</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151690627</td>\n      <td>0</td>\n      <td>项目策划专员（2024届秋招-北京）</td>\n      <td>[在校生/应届生, 本科, 市场营销, 市场调研, 广告, 方案撰写, 广告营销, 社会化营...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151690627...</td>\n      <td>2966</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151434503</td>\n      <td>0</td>\n      <td>电影项目策划</td>\n      <td>[1年, 本科, 五险一金, 交通补贴, 餐饮补贴, 绩效奖金, 年终奖金, 定期体检, 专...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151434503...</td>\n      <td>7891066</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>149271479</td>\n      <td>0</td>\n      <td>广告文案策划</td>\n      <td>[无需经验, 大专]</td>\n      <td></td>\n      <td>010100</td>\n      <td>010000</td>\n      <td>北京·东城区</td>\n      <td>beijing-dcq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=149271479...</td>\n      <td>7920322</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>东城区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151359145</td>\n      <td>0</td>\n      <td>影视策划</td>\n      <td>[1年, 本科, 市场信息, 中文, 编导, 导演, 市场调研分析, 策划案, 戏文, 电视...</td>\n      <td></td>\n      <td>020000</td>\n      <td>010000</td>\n      <td>上海</td>\n      <td>shanghai</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151359145...</td>\n      <td>2136652</td>\n      <td>上海</td>\n      <td>上海</td>\n      <td>NaN</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150339612</td>\n      <td>0</td>\n      <td>百匠新人-营销策划岗</td>\n      <td>[在校生/应届生, 硕士]</td>\n      <td>若干</td>\n      <td>010600</td>\n      <td>010000</td>\n      <td>北京·丰台区</td>\n      <td>beijing-ftq</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=150339612...</td>\n      <td>7371440</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151434586</td>\n      <td>0</td>\n      <td>电视剧项目策划</td>\n      <td>[1年, 本科, 文学, 影视, 戏剧, 创意, 五险一金, 交通补贴, 餐饮补贴, 绩效奖...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151434586...</td>\n      <td>7891066</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150164667</td>\n      <td>0</td>\n      <td>短视频文案策划</td>\n      <td>[1年, 本科, 广告短视频, 广告文案, 文案, 电商文案, 抖音, 品牌调性, 平台调性...</td>\n      <td></td>\n      <td>010000</td>\n      <td>010000</td>\n      <td>北京</td>\n      <td>beijing</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=150164667...</td>\n      <td>2648835</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151982365</td>\n      <td>0</td>\n      <td>影视策划（兼职）</td>\n      <td>[1年, 本科, 市场信息, 中文, 编导, 导演, 市场调研分析, 策划案, 戏文, 电视...</td>\n      <td></td>\n      <td>020000</td>\n      <td>010000</td>\n      <td>上海</td>\n      <td>shanghai</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151982365...</td>\n      <td>2136652</td>\n      <td>上海</td>\n      <td>上海</td>\n      <td>NaN</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150374576</td>\n      <td>0</td>\n      <td>万象生-活动策划岗</td>\n      <td>[在校生/应届生, 本科]</td>\n      <td>若干</td>\n      <td>010000</td>\n      <td>010000</td>\n      <td>北京</td>\n      <td>beijing</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=150374576...</td>\n      <td>7371440</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151078104</td>\n      <td>0</td>\n      <td>媒介策划执行（2024届秋招-北京）</td>\n      <td>[在校生/应届生, 本科]</td>\n      <td>4</td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=151078104...</td>\n      <td>8162604</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150164515</td>\n      <td>0</td>\n      <td>短视频策划/编导</td>\n      <td>[1年, 本科, 五险一金, 员工旅游, 年终奖金, 绩效奖金]</td>\n      <td></td>\n      <td>010000</td>\n      <td>010000</td>\n      <td>北京</td>\n      <td>beijing</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=150164515...</td>\n      <td>2648835</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151081284</td>\n      <td>0</td>\n      <td>品牌策划</td>\n      <td>[在校生/应届生, 本科, 广告学, 传播学, 五险一金, 免费班车, 补充医疗保险, 通讯...</td>\n      <td>10</td>\n      <td>011100</td>\n      <td>010000</td>\n      <td>北京·通州区</td>\n      <td>beijing-tzq</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=151081284...</td>\n      <td>8166484</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>通州区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>152127685</td>\n      <td>0</td>\n      <td>品牌策划</td>\n      <td>[1年, 本科, 办公软件, 项目管理, 营销, 品牌推广, 广告, 项目策划, 报告撰写,...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=152127685...</td>\n      <td>2234206</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>137789041</td>\n      <td>0</td>\n      <td>撰稿策划</td>\n      <td>[1年, 大专, 五险一金]</td>\n      <td></td>\n      <td>010800</td>\n      <td>010000</td>\n      <td>北京·海淀区</td>\n      <td>beijing-hdq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=137789041...</td>\n      <td>688313</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>海淀区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>132202501</td>\n      <td>0</td>\n      <td>创意文案策划</td>\n      <td>[1年, 本科, 传播学, 跨媒体艺术, 策划, 文案, 新媒体, 餐饮补贴, 五险一金, ...</td>\n      <td></td>\n      <td>010600</td>\n      <td>010000</td>\n      <td>北京·丰台区</td>\n      <td>beijing-ftq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=132202501...</td>\n      <td>6191079</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>147183336</td>\n      <td>0</td>\n      <td>客户执行/AE（北京）</td>\n      <td>[在校生/应届生, 大专, 广告, 公关, 媒体, 五险一金, 餐饮补贴, 年终奖金, 定期体检]</td>\n      <td>若干</td>\n      <td>010000</td>\n      <td>010000</td>\n      <td>北京</td>\n      <td>beijing</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=147183336...</td>\n      <td>7702328</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td></td>\n      <td></td>\n      <td></td>\n      <td></td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>149118726</td>\n      <td>0</td>\n      <td>广告客户经理</td>\n      <td>[1年, 本科, 广告, 营销, 传媒, 互联网, 销售, 客户经理, 业务员, 销售经理,...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=149118726...</td>\n      <td>7903457</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>CBD</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151734889</td>\n      <td>0</td>\n      <td>票据录入文员</td>\n      <td>[无需经验, 大专, 数据统计, 统计报表, 校对, 节日福利, 社保, 绩效奖金, 弹性工...</td>\n      <td></td>\n      <td>010500</td>\n      <td>010000</td>\n      <td>北京·朝阳区</td>\n      <td>beijing-cyq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151734889...</td>\n      <td>2959530</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>133687600</td>\n      <td>0</td>\n      <td>品牌策划经理</td>\n      <td>[1年, 本科, 市场营销, 商务管理, 五险一金, 绩效奖金]</td>\n      <td></td>\n      <td>010600</td>\n      <td>010000</td>\n      <td>北京·丰台区</td>\n      <td>beijing-ftq</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=133687600...</td>\n      <td>6191079</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td></td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>117352119</td>\n      <td>0</td>\n      <td>活动策划执行</td>\n      <td>[1年, 本科, 五险一金, 周末双休, 弹性工作, 带薪年假, 绩效奖金, 节日福利, 餐...</td>\n      <td></td>\n      <td>010000</td>\n      <td>010000</td>\n      <td>北京</td>\n      <td>beijing</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=117352119...</td>\n      <td>3499944</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>崇文门</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>20 rows × 77 columns</p>\n</div>"
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_wuyou = pd.json_normalize(response_data['resultbody']['job']['items'])\n",
    "df_wuyou"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "outputs": [
    {
     "data": {
      "text/plain": "'北京'"
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citi_name = str(城市)\n",
    "citi_name"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "outputs": [
    {
     "data": {
      "text/plain": "'广告策划'"
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key = str(关键字)\n",
    "key"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "outputs": [
    {
     "data": {
      "text/plain": "'2023-12-1_11-21'"
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import time\n",
    "time.localtime()\n",
    "output_time = str(time.localtime().tm_year)+'-'\\\n",
    "              +str(time.localtime().tm_mon)+'-'\\\n",
    "             +str(time.localtime().tm_mday)+'_'\\\n",
    "             +str(time.localtime().tm_hour)+'-' \\\n",
    "             +str(time.localtime().tm_min)\n",
    "output_time"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [],
   "source": [
    "df_wuyou.to_excel('前程无忧'+citi_name+key+output_time+'.xlsx')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "outputs": [],
   "source": [
    "import pandas as pd"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "outputs": [
    {
     "data": {
      "text/plain": "    Unnamed: 0                                           property      jobId  \\\n0            0  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151690627   \n1            1  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151434503   \n2            2  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  149271479   \n3            3  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151359145   \n4            4  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150339612   \n5            5  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151434586   \n6            6  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150164667   \n7            7  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151982365   \n8            8  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150374576   \n9            9  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151078104   \n10          10  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  150164515   \n11          11  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151081284   \n12          12  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  152127685   \n13          13  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  137789041   \n14          14  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  132202501   \n15          15  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  147183336   \n16          16  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  149118726   \n17          17  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  151734889   \n18          18  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  133687600   \n19          19  {\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...  117352119   \n\n    jobType             jobName  \\\n0         0  项目策划专员（2024届秋招-北京）   \n1         0              电影项目策划   \n2         0              广告文案策划   \n3         0                影视策划   \n4         0          百匠新人-营销策划岗   \n5         0             电视剧项目策划   \n6         0             短视频文案策划   \n7         0            影视策划（兼职）   \n8         0           万象生-活动策划岗   \n9         0  媒介策划执行（2024届秋招-北京）   \n10        0            短视频策划/编导   \n11        0                品牌策划   \n12        0                品牌策划   \n13        0                撰稿策划   \n14        0              创意文案策划   \n15        0         客户执行/AE（北京）   \n16        0              广告客户经理   \n17        0              票据录入文员   \n18        0              品牌策划经理   \n19        0              活动策划执行   \n\n                                              jobTags jobNumString  \\\n0   ['在校生/应届生', '本科', '市场营销', '市场调研', '广告', '方案撰写'...          NaN   \n1   ['1年', '本科', '五险一金', '交通补贴', '餐饮补贴', '绩效奖金', '...          NaN   \n2                                      ['无需经验', '大专']          NaN   \n3   ['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...          NaN   \n4                                   ['在校生/应届生', '硕士']           若干   \n5   ['1年', '本科', '文学', '影视', '戏剧', '创意', '五险一金', '...          NaN   \n6   ['1年', '本科', '广告短视频', '广告文案', '文案', '电商文案', '抖...          NaN   \n7   ['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...          NaN   \n8                                   ['在校生/应届生', '本科']           若干   \n9                                   ['在校生/应届生', '本科']            4   \n10       ['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金']          NaN   \n11  ['在校生/应届生', '本科', '广告学', '传播学', '五险一金', '免费班车'...           10   \n12  ['1年', '本科', '办公软件', '项目管理', '营销', '品牌推广', '广告...          NaN   \n13                               ['1年', '大专', '五险一金']          NaN   \n14  ['1年', '本科', '传播学', '跨媒体艺术', '策划', '文案', '新媒体'...          NaN   \n15  ['在校生/应届生', '大专', '广告', '公关', '媒体', '五险一金', '餐...           若干   \n16  ['1年', '本科', '广告', '营销', '传媒', '互联网', '销售', '客...          NaN   \n17  ['无需经验', '大专', '数据统计', '统计报表', '校对', '节日福利', '...          NaN   \n18       ['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金']          NaN   \n19  ['1年', '本科', '五险一金', '周末双休', '弹性工作', '带薪年假', '...          NaN   \n\n    workAreaCode  jobAreaCode jobAreaString  ... isAllowChat  \\\n0          10500        10000        北京·朝阳区  ...        True   \n1          10500        10000        北京·朝阳区  ...        True   \n2          10100        10000        北京·东城区  ...        True   \n3          20000        10000            上海  ...        True   \n4          10600        10000        北京·丰台区  ...       False   \n5          10500        10000        北京·朝阳区  ...        True   \n6          10000        10000            北京  ...        True   \n7          20000        10000            上海  ...        True   \n8          10000        10000            北京  ...       False   \n9          10500        10000        北京·朝阳区  ...       False   \n10         10000        10000            北京  ...        True   \n11         11100        10000        北京·通州区  ...       False   \n12         10500        10000        北京·朝阳区  ...        True   \n13         10800        10000        北京·海淀区  ...        True   \n14         10600        10000        北京·丰台区  ...        True   \n15         10000        10000            北京  ...       False   \n16         10500        10000        北京·朝阳区  ...        True   \n17         10500        10000        北京·朝阳区  ...        True   \n18         10600        10000        北京·丰台区  ...        True   \n19         10000        10000            北京  ...        True   \n\n                                            jobScheme     coId  \\\n0   qiancheng://home/show_job_info?jobid=151690627...     2966   \n1   qiancheng://home/show_job_info?jobid=151434503...  7891066   \n2   qiancheng://home/show_job_info?jobid=149271479...  7920322   \n3   qiancheng://home/show_job_info?jobid=151359145...  2136652   \n4   qiancheng://home/show_job_info?jobid=150339612...  7371440   \n5   qiancheng://home/show_job_info?jobid=151434586...  7891066   \n6   qiancheng://home/show_job_info?jobid=150164667...  2648835   \n7   qiancheng://home/show_job_info?jobid=151982365...  2136652   \n8   qiancheng://home/show_job_info?jobid=150374576...  7371440   \n9   qiancheng://home/show_job_info?jobid=151078104...  8162604   \n10  qiancheng://home/show_job_info?jobid=150164515...  2648835   \n11  qiancheng://home/show_job_info?jobid=151081284...  8166484   \n12  qiancheng://home/show_job_info?jobid=152127685...  2234206   \n13  qiancheng://home/show_job_info?jobid=137789041...   688313   \n14  qiancheng://home/show_job_info?jobid=132202501...  6191079   \n15  qiancheng://home/show_job_info?jobid=147183336...  7702328   \n16  qiancheng://home/show_job_info?jobid=149118726...  7903457   \n17  qiancheng://home/show_job_info?jobid=151734889...  2959530   \n18  qiancheng://home/show_job_info?jobid=133687600...  6191079   \n19  qiancheng://home/show_job_info?jobid=117352119...  3499944   \n\n   jobAreaLevelDetail.provinceString  jobAreaLevelDetail.cityString  \\\n0                                 北京                             北京   \n1                                 北京                             北京   \n2                                 北京                             北京   \n3                                 上海                             上海   \n4                                 北京                             北京   \n5                                 北京                             北京   \n6                                 北京                             北京   \n7                                 上海                             上海   \n8                                 北京                             北京   \n9                                 北京                             北京   \n10                                北京                             北京   \n11                                北京                             北京   \n12                                北京                             北京   \n13                                北京                             北京   \n14                                北京                             北京   \n15                                北京                             北京   \n16                                北京                             北京   \n17                                北京                             北京   \n18                                北京                             北京   \n19                                北京                             北京   \n\n   jobAreaLevelDetail.districtString jobAreaLevelDetail.landMarkString  \\\n0                                朝阳区                               NaN   \n1                                朝阳区                               NaN   \n2                                东城区                               NaN   \n3                                NaN                               NaN   \n4                                丰台区                               NaN   \n5                                朝阳区                               NaN   \n6                                NaN                               NaN   \n7                                NaN                               NaN   \n8                                NaN                               NaN   \n9                                朝阳区                               NaN   \n10                               NaN                               NaN   \n11                               通州区                               NaN   \n12                               朝阳区                               NaN   \n13                               海淀区                               NaN   \n14                               丰台区                               NaN   \n15                               NaN                               NaN   \n16                               朝阳区                               CBD   \n17                               朝阳区                               NaN   \n18                               丰台区                               NaN   \n19                               NaN                               崇文门   \n\n    contactAllowed  contactDay contactTime  \n0              NaN         NaN         NaN  \n1              NaN         NaN         NaN  \n2              NaN         NaN         NaN  \n3              NaN         NaN         NaN  \n4              NaN         NaN         NaN  \n5              NaN         NaN         NaN  \n6              NaN         NaN         NaN  \n7              NaN         NaN         NaN  \n8              NaN         NaN         NaN  \n9              NaN         NaN         NaN  \n10             NaN         NaN         NaN  \n11             NaN         NaN         NaN  \n12             NaN         NaN         NaN  \n13             NaN         NaN         NaN  \n14             NaN         NaN         NaN  \n15             NaN         NaN         NaN  \n16             NaN         NaN         NaN  \n17             NaN         NaN         NaN  \n18             NaN         NaN         NaN  \n19             NaN         NaN         NaN  \n\n[20 rows x 78 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>Unnamed: 0</th>\n      <th>property</th>\n      <th>jobId</th>\n      <th>jobType</th>\n      <th>jobName</th>\n      <th>jobTags</th>\n      <th>jobNumString</th>\n      <th>workAreaCode</th>\n      <th>jobAreaCode</th>\n      <th>jobAreaString</th>\n      <th>...</th>\n      <th>isAllowChat</th>\n      <th>jobScheme</th>\n      <th>coId</th>\n      <th>jobAreaLevelDetail.provinceString</th>\n      <th>jobAreaLevelDetail.cityString</th>\n      <th>jobAreaLevelDetail.districtString</th>\n      <th>jobAreaLevelDetail.landMarkString</th>\n      <th>contactAllowed</th>\n      <th>contactDay</th>\n      <th>contactTime</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151690627</td>\n      <td>0</td>\n      <td>项目策划专员（2024届秋招-北京）</td>\n      <td>['在校生/应届生', '本科', '市场营销', '市场调研', '广告', '方案撰写'...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151690627...</td>\n      <td>2966</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151434503</td>\n      <td>0</td>\n      <td>电影项目策划</td>\n      <td>['1年', '本科', '五险一金', '交通补贴', '餐饮补贴', '绩效奖金', '...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151434503...</td>\n      <td>7891066</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>149271479</td>\n      <td>0</td>\n      <td>广告文案策划</td>\n      <td>['无需经验', '大专']</td>\n      <td>NaN</td>\n      <td>10100</td>\n      <td>10000</td>\n      <td>北京·东城区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=149271479...</td>\n      <td>7920322</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>东城区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>3</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151359145</td>\n      <td>0</td>\n      <td>影视策划</td>\n      <td>['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...</td>\n      <td>NaN</td>\n      <td>20000</td>\n      <td>10000</td>\n      <td>上海</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151359145...</td>\n      <td>2136652</td>\n      <td>上海</td>\n      <td>上海</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>4</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150339612</td>\n      <td>0</td>\n      <td>百匠新人-营销策划岗</td>\n      <td>['在校生/应届生', '硕士']</td>\n      <td>若干</td>\n      <td>10600</td>\n      <td>10000</td>\n      <td>北京·丰台区</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=150339612...</td>\n      <td>7371440</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>5</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151434586</td>\n      <td>0</td>\n      <td>电视剧项目策划</td>\n      <td>['1年', '本科', '文学', '影视', '戏剧', '创意', '五险一金', '...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151434586...</td>\n      <td>7891066</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>6</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150164667</td>\n      <td>0</td>\n      <td>短视频文案策划</td>\n      <td>['1年', '本科', '广告短视频', '广告文案', '文案', '电商文案', '抖...</td>\n      <td>NaN</td>\n      <td>10000</td>\n      <td>10000</td>\n      <td>北京</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=150164667...</td>\n      <td>2648835</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>7</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151982365</td>\n      <td>0</td>\n      <td>影视策划（兼职）</td>\n      <td>['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...</td>\n      <td>NaN</td>\n      <td>20000</td>\n      <td>10000</td>\n      <td>上海</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151982365...</td>\n      <td>2136652</td>\n      <td>上海</td>\n      <td>上海</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>8</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150374576</td>\n      <td>0</td>\n      <td>万象生-活动策划岗</td>\n      <td>['在校生/应届生', '本科']</td>\n      <td>若干</td>\n      <td>10000</td>\n      <td>10000</td>\n      <td>北京</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=150374576...</td>\n      <td>7371440</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>9</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151078104</td>\n      <td>0</td>\n      <td>媒介策划执行（2024届秋招-北京）</td>\n      <td>['在校生/应届生', '本科']</td>\n      <td>4</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=151078104...</td>\n      <td>8162604</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>10</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>150164515</td>\n      <td>0</td>\n      <td>短视频策划/编导</td>\n      <td>['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金']</td>\n      <td>NaN</td>\n      <td>10000</td>\n      <td>10000</td>\n      <td>北京</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=150164515...</td>\n      <td>2648835</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>11</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151081284</td>\n      <td>0</td>\n      <td>品牌策划</td>\n      <td>['在校生/应届生', '本科', '广告学', '传播学', '五险一金', '免费班车'...</td>\n      <td>10</td>\n      <td>11100</td>\n      <td>10000</td>\n      <td>北京·通州区</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=151081284...</td>\n      <td>8166484</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>通州区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>12</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>152127685</td>\n      <td>0</td>\n      <td>品牌策划</td>\n      <td>['1年', '本科', '办公软件', '项目管理', '营销', '品牌推广', '广告...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=152127685...</td>\n      <td>2234206</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>13</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>137789041</td>\n      <td>0</td>\n      <td>撰稿策划</td>\n      <td>['1年', '大专', '五险一金']</td>\n      <td>NaN</td>\n      <td>10800</td>\n      <td>10000</td>\n      <td>北京·海淀区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=137789041...</td>\n      <td>688313</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>海淀区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>14</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>132202501</td>\n      <td>0</td>\n      <td>创意文案策划</td>\n      <td>['1年', '本科', '传播学', '跨媒体艺术', '策划', '文案', '新媒体'...</td>\n      <td>NaN</td>\n      <td>10600</td>\n      <td>10000</td>\n      <td>北京·丰台区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=132202501...</td>\n      <td>6191079</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>15</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>147183336</td>\n      <td>0</td>\n      <td>客户执行/AE（北京）</td>\n      <td>['在校生/应届生', '大专', '广告', '公关', '媒体', '五险一金', '餐...</td>\n      <td>若干</td>\n      <td>10000</td>\n      <td>10000</td>\n      <td>北京</td>\n      <td>...</td>\n      <td>False</td>\n      <td>qiancheng://home/show_job_info?jobid=147183336...</td>\n      <td>7702328</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>16</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>149118726</td>\n      <td>0</td>\n      <td>广告客户经理</td>\n      <td>['1年', '本科', '广告', '营销', '传媒', '互联网', '销售', '客...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=149118726...</td>\n      <td>7903457</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>CBD</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>17</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>151734889</td>\n      <td>0</td>\n      <td>票据录入文员</td>\n      <td>['无需经验', '大专', '数据统计', '统计报表', '校对', '节日福利', '...</td>\n      <td>NaN</td>\n      <td>10500</td>\n      <td>10000</td>\n      <td>北京·朝阳区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=151734889...</td>\n      <td>2959530</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>朝阳区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>18</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>133687600</td>\n      <td>0</td>\n      <td>品牌策划经理</td>\n      <td>['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金']</td>\n      <td>NaN</td>\n      <td>10600</td>\n      <td>10000</td>\n      <td>北京·丰台区</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=133687600...</td>\n      <td>6191079</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>丰台区</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>19</td>\n      <td>{\"isInitiative\":\"是\",\"pageCode\":\"sou|sou|soulb\"...</td>\n      <td>117352119</td>\n      <td>0</td>\n      <td>活动策划执行</td>\n      <td>['1年', '本科', '五险一金', '周末双休', '弹性工作', '带薪年假', '...</td>\n      <td>NaN</td>\n      <td>10000</td>\n      <td>10000</td>\n      <td>北京</td>\n      <td>...</td>\n      <td>True</td>\n      <td>qiancheng://home/show_job_info?jobid=117352119...</td>\n      <td>3499944</td>\n      <td>北京</td>\n      <td>北京</td>\n      <td>NaN</td>\n      <td>崇文门</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n  </tbody>\n</table>\n<p>20 rows × 78 columns</p>\n</div>"
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "read_df = pd.read_excel('前程无忧'+citi_name+key+output_time+'.xlsx')\n",
    "read_df"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "outputs": [],
   "source": [
    "df_wuyou_job = read_df[['jobName','jobTags','jobAreaString','provideSalaryString','workYearString','degreeString','industryType1Str','companyName','companyTypeString','companySizeString','hrName','hrPosition','updateDateTime','jobHref','companyHref']]"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "outputs": [
    {
     "data": {
      "text/plain": "               jobName                                            jobTags  \\\n0   项目策划专员（2024届秋招-北京）  ['在校生/应届生', '本科', '市场营销', '市场调研', '广告', '方案撰写'...   \n1               电影项目策划  ['1年', '本科', '五险一金', '交通补贴', '餐饮补贴', '绩效奖金', '...   \n2               广告文案策划                                     ['无需经验', '大专']   \n3                 影视策划  ['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...   \n4           百匠新人-营销策划岗                                  ['在校生/应届生', '硕士']   \n5              电视剧项目策划  ['1年', '本科', '文学', '影视', '戏剧', '创意', '五险一金', '...   \n6              短视频文案策划  ['1年', '本科', '广告短视频', '广告文案', '文案', '电商文案', '抖...   \n7             影视策划（兼职）  ['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...   \n8            万象生-活动策划岗                                  ['在校生/应届生', '本科']   \n9   媒介策划执行（2024届秋招-北京）                                  ['在校生/应届生', '本科']   \n10            短视频策划/编导       ['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金']   \n11                品牌策划  ['在校生/应届生', '本科', '广告学', '传播学', '五险一金', '免费班车'...   \n12                品牌策划  ['1年', '本科', '办公软件', '项目管理', '营销', '品牌推广', '广告...   \n13                撰稿策划                               ['1年', '大专', '五险一金']   \n14              创意文案策划  ['1年', '本科', '传播学', '跨媒体艺术', '策划', '文案', '新媒体'...   \n15         客户执行/AE（北京）  ['在校生/应届生', '大专', '广告', '公关', '媒体', '五险一金', '餐...   \n16              广告客户经理  ['1年', '本科', '广告', '营销', '传媒', '互联网', '销售', '客...   \n17              票据录入文员  ['无需经验', '大专', '数据统计', '统计报表', '校对', '节日福利', '...   \n18              品牌策划经理       ['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金']   \n19              活动策划执行  ['1年', '本科', '五险一金', '周末双休', '弹性工作', '带薪年假', '...   \n\n   jobAreaString provideSalaryString workYearString degreeString  \\\n0         北京·朝阳区            6-9千·13薪        在校生/应届生           本科   \n1         北京·朝阳区                5-8千             1年           本科   \n2         北京·东城区             6千-1.2万           无需经验           大专   \n3             上海                1-2万             1年           本科   \n4         北京·丰台区           7.5千-1.5万        在校生/应届生           硕士   \n5         北京·朝阳区                5-8千             1年           本科   \n6             北京              1-1.2万             1年           本科   \n7             上海             6千-1.2万             1年           本科   \n8             北京           8.4千-1.1万        在校生/应届生           本科   \n9         北京·朝阳区                6-8千        在校生/应届生           本科   \n10            北京             8千-1.2万             1年           本科   \n11        北京·通州区              5.5-8千        在校生/应届生           本科   \n12        北京·朝阳区               7千-1万             1年           本科   \n13        北京·海淀区             8千-1.5万             1年           大专   \n14        北京·丰台区             9千-1.2万             1年           本科   \n15            北京            6-8千·13薪        在校生/应届生           大专   \n16        北京·朝阳区                2-4万             1年           本科   \n17        北京·朝阳区                4-5千           无需经验           大专   \n18        北京·丰台区              1-1.5万             1年           本科   \n19            北京                6-9千             1年           本科   \n\n   industryType1Str           companyName companyTypeString companySizeString  \\\n0                广告               广东省广告集团               已上市        1000-5000人   \n1     影视/媒体/艺术/文化传播  幸福蓝海影视文化集团股份有限公司北京广告                国企               NaN   \n2             计算机软件           固城湖（北京）影视传媒                民营               NaN   \n3                广告               上海黑开唛广告                民营           50-150人   \n4               房地产                华润置地控股                国企               NaN   \n5     影视/媒体/艺术/文化传播  幸福蓝海影视文化集团股份有限公司北京广告                国企               NaN   \n6                广告              北京金色沸点广告                民营             少于50人   \n7                广告               上海黑开唛广告                民营           50-150人   \n8               房地产                华润置地控股                国企               NaN   \n9          金融/投资/证券             广东省广新控股集团                国企               NaN   \n10               广告              北京金色沸点广告                民营             少于50人   \n11      家具/家电/玩具/礼品              北京闼闼同创工贸                民营               NaN   \n12    影视/媒体/艺术/文化传播                保利影业投资                国企          150-500人   \n13               广告              北京创意支点广告                民营             少于50人   \n14               广告             北京天策行品牌顾问                民营             少于50人   \n15        多元化业务集团公司               北京天下秀广告                民营               NaN   \n16            计算机软件              上海阿牛信息科技                民营          150-500人   \n17               广告            成都上品集创广告策划                民营           50-150人   \n18               广告             北京天策行品牌顾问                民营             少于50人   \n19         互联网/电子商务                 中国家电网                国企           50-150人   \n\n       hrName hrPosition       updateDateTime  \\\n0      Summer     高级招聘经理  2023-11-01 09:15:06   \n1        幸福蓝海       招聘经理  2023-11-28 13:44:44   \n2           杨         财务  2023-11-23 14:31:40   \n3   上海黑开唛广告公司         HR  2023-11-13 15:09:16   \n4         NaN        NaN  2023-11-30 04:53:24   \n5        幸福蓝海       招聘经理  2023-11-28 13:44:36   \n6        金色沸点         人事  2023-10-26 16:53:32   \n7   上海黑开唛广告公司         HR  2023-11-13 15:22:02   \n8         NaN        NaN  2023-12-01 04:30:55   \n9         NaN        NaN  2023-10-27 14:29:23   \n10       金色沸点         人事  2023-10-26 16:53:52   \n11        NaN        NaN  2023-09-22 11:44:37   \n12   保利文娱科技HR         HR  2023-11-21 13:26:38   \n13      admin       人事招聘  2023-07-18 10:00:45   \n14   tcxv7967        总经理  2023-11-06 16:57:02   \n15        NaN        NaN  2023-12-01 04:41:23   \n16        凌女士         HR  2023-07-06 15:50:13   \n17        罗女士         HR  2023-10-31 09:49:37   \n18   tcxv7967        总经理  2023-11-06 16:56:36   \n19      中国家电网       人事主管  2023-11-07 16:34:33   \n\n                                              jobHref  \\\n0   https://jobs.51job.com/beijing-cyq/151690627.h...   \n1   https://jobs.51job.com/beijing-cyq/151434503.h...   \n2   https://jobs.51job.com/beijing-dcq/149271479.h...   \n3   https://jobs.51job.com/shanghai/151359145.html...   \n4   https://jobs.51job.com/beijing-ftq/150339612.h...   \n5   https://jobs.51job.com/beijing-cyq/151434586.h...   \n6   https://jobs.51job.com/beijing/150164667.html?...   \n7   https://jobs.51job.com/shanghai/151982365.html...   \n8   https://jobs.51job.com/beijing/150374576.html?...   \n9   https://jobs.51job.com/beijing-cyq/151078104.h...   \n10  https://jobs.51job.com/beijing/150164515.html?...   \n11  https://jobs.51job.com/beijing-tzq/151081284.h...   \n12  https://jobs.51job.com/beijing-cyq/152127685.h...   \n13  https://jobs.51job.com/beijing-hdq/137789041.h...   \n14  https://jobs.51job.com/beijing-ftq/132202501.h...   \n15  https://jobs.51job.com/beijing/147183336.html?...   \n16  https://jobs.51job.com/beijing-cyq/149118726.h...   \n17  https://jobs.51job.com/beijing-cyq/151734889.h...   \n18  https://jobs.51job.com/beijing-ftq/133687600.h...   \n19  https://jobs.51job.com/beijing/117352119.html?...   \n\n                                          companyHref  \n0       https://jobs.51job.com/all/coBmJRPAdiBDw.html  \n1   https://jobs.51job.com/all/coAmNRPV40UW4GYwZjU...  \n2   https://jobs.51job.com/all/coAGFRPABhBTtWMAdmB...  \n3   https://jobs.51job.com/all/coBmIFYFAwADhVNgxqX...  \n4   https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2U...  \n5   https://jobs.51job.com/all/coAmNRPV40UW4GYwZjU...  \n6   https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhA...  \n7   https://jobs.51job.com/all/coBmIFYFAwADhVNgxqX...  \n8   https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2U...  \n9   https://jobs.51job.com/all/coAmxTNgVgBDgCYVc0V...  \n10  https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhA...  \n11  https://jobs.51job.com/all/coUT8CZwVgADhVNAVuU...  \n12  https://jobs.51job.com/all/coUjZcOlU1DzUOaQJhU...  \n13  https://jobs.51job.com/all/coVjZTP141U25UMFAw....  \n14  https://jobs.51job.com/all/coBGRQNV40VmkCZwZiU...  \n15  https://jobs.51job.com/all/coCGlcP1IxVGgFY1Q1U...  \n16  https://jobs.51job.com/all/coA2JWOwNgUm8CYwVjB...  \n17  https://jobs.51job.com/all/coVDBSP1QyAzQFZQxsA...  \n18  https://jobs.51job.com/all/coBGRQNV40VmkCZwZiU...  \n19  https://jobs.51job.com/all/coAmcGZlM5DzgPY1QzB...  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>jobName</th>\n      <th>jobTags</th>\n      <th>jobAreaString</th>\n      <th>provideSalaryString</th>\n      <th>workYearString</th>\n      <th>degreeString</th>\n      <th>industryType1Str</th>\n      <th>companyName</th>\n      <th>companyTypeString</th>\n      <th>companySizeString</th>\n      <th>hrName</th>\n      <th>hrPosition</th>\n      <th>updateDateTime</th>\n      <th>jobHref</th>\n      <th>companyHref</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>项目策划专员（2024届秋招-北京）</td>\n      <td>['在校生/应届生', '本科', '市场营销', '市场调研', '广告', '方案撰写'...</td>\n      <td>北京·朝阳区</td>\n      <td>6-9千·13薪</td>\n      <td>在校生/应届生</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>广东省广告集团</td>\n      <td>已上市</td>\n      <td>1000-5000人</td>\n      <td>Summer</td>\n      <td>高级招聘经理</td>\n      <td>2023-11-01 09:15:06</td>\n      <td>https://jobs.51job.com/beijing-cyq/151690627.h...</td>\n      <td>https://jobs.51job.com/all/coBmJRPAdiBDw.html</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>电影项目策划</td>\n      <td>['1年', '本科', '五险一金', '交通补贴', '餐饮补贴', '绩效奖金', '...</td>\n      <td>北京·朝阳区</td>\n      <td>5-8千</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>影视/媒体/艺术/文化传播</td>\n      <td>幸福蓝海影视文化集团股份有限公司北京广告</td>\n      <td>国企</td>\n      <td>NaN</td>\n      <td>幸福蓝海</td>\n      <td>招聘经理</td>\n      <td>2023-11-28 13:44:44</td>\n      <td>https://jobs.51job.com/beijing-cyq/151434503.h...</td>\n      <td>https://jobs.51job.com/all/coAmNRPV40UW4GYwZjU...</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>广告文案策划</td>\n      <td>['无需经验', '大专']</td>\n      <td>北京·东城区</td>\n      <td>6千-1.2万</td>\n      <td>无需经验</td>\n      <td>大专</td>\n      <td>计算机软件</td>\n      <td>固城湖（北京）影视传媒</td>\n      <td>民营</td>\n      <td>NaN</td>\n      <td>杨</td>\n      <td>财务</td>\n      <td>2023-11-23 14:31:40</td>\n      <td>https://jobs.51job.com/beijing-dcq/149271479.h...</td>\n      <td>https://jobs.51job.com/all/coAGFRPABhBTtWMAdmB...</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>影视策划</td>\n      <td>['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...</td>\n      <td>上海</td>\n      <td>1-2万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>上海黑开唛广告</td>\n      <td>民营</td>\n      <td>50-150人</td>\n      <td>上海黑开唛广告公司</td>\n      <td>HR</td>\n      <td>2023-11-13 15:09:16</td>\n      <td>https://jobs.51job.com/shanghai/151359145.html...</td>\n      <td>https://jobs.51job.com/all/coBmIFYFAwADhVNgxqX...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>百匠新人-营销策划岗</td>\n      <td>['在校生/应届生', '硕士']</td>\n      <td>北京·丰台区</td>\n      <td>7.5千-1.5万</td>\n      <td>在校生/应届生</td>\n      <td>硕士</td>\n      <td>房地产</td>\n      <td>华润置地控股</td>\n      <td>国企</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2023-11-30 04:53:24</td>\n      <td>https://jobs.51job.com/beijing-ftq/150339612.h...</td>\n      <td>https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2U...</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>电视剧项目策划</td>\n      <td>['1年', '本科', '文学', '影视', '戏剧', '创意', '五险一金', '...</td>\n      <td>北京·朝阳区</td>\n      <td>5-8千</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>影视/媒体/艺术/文化传播</td>\n      <td>幸福蓝海影视文化集团股份有限公司北京广告</td>\n      <td>国企</td>\n      <td>NaN</td>\n      <td>幸福蓝海</td>\n      <td>招聘经理</td>\n      <td>2023-11-28 13:44:36</td>\n      <td>https://jobs.51job.com/beijing-cyq/151434586.h...</td>\n      <td>https://jobs.51job.com/all/coAmNRPV40UW4GYwZjU...</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>短视频文案策划</td>\n      <td>['1年', '本科', '广告短视频', '广告文案', '文案', '电商文案', '抖...</td>\n      <td>北京</td>\n      <td>1-1.2万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>北京金色沸点广告</td>\n      <td>民营</td>\n      <td>少于50人</td>\n      <td>金色沸点</td>\n      <td>人事</td>\n      <td>2023-10-26 16:53:32</td>\n      <td>https://jobs.51job.com/beijing/150164667.html?...</td>\n      <td>https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhA...</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>影视策划（兼职）</td>\n      <td>['1年', '本科', '市场信息', '中文', '编导', '导演', '市场调研分析...</td>\n      <td>上海</td>\n      <td>6千-1.2万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>上海黑开唛广告</td>\n      <td>民营</td>\n      <td>50-150人</td>\n      <td>上海黑开唛广告公司</td>\n      <td>HR</td>\n      <td>2023-11-13 15:22:02</td>\n      <td>https://jobs.51job.com/shanghai/151982365.html...</td>\n      <td>https://jobs.51job.com/all/coBmIFYFAwADhVNgxqX...</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>万象生-活动策划岗</td>\n      <td>['在校生/应届生', '本科']</td>\n      <td>北京</td>\n      <td>8.4千-1.1万</td>\n      <td>在校生/应届生</td>\n      <td>本科</td>\n      <td>房地产</td>\n      <td>华润置地控股</td>\n      <td>国企</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2023-12-01 04:30:55</td>\n      <td>https://jobs.51job.com/beijing/150374576.html?...</td>\n      <td>https://jobs.51job.com/all/coB2ZRNgNnUW5RMFE2U...</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>媒介策划执行（2024届秋招-北京）</td>\n      <td>['在校生/应届生', '本科']</td>\n      <td>北京·朝阳区</td>\n      <td>6-8千</td>\n      <td>在校生/应届生</td>\n      <td>本科</td>\n      <td>金融/投资/证券</td>\n      <td>广东省广新控股集团</td>\n      <td>国企</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2023-10-27 14:29:23</td>\n      <td>https://jobs.51job.com/beijing-cyq/151078104.h...</td>\n      <td>https://jobs.51job.com/all/coAmxTNgVgBDgCYVc0V...</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>短视频策划/编导</td>\n      <td>['1年', '本科', '五险一金', '员工旅游', '年终奖金', '绩效奖金']</td>\n      <td>北京</td>\n      <td>8千-1.2万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>北京金色沸点广告</td>\n      <td>民营</td>\n      <td>少于50人</td>\n      <td>金色沸点</td>\n      <td>人事</td>\n      <td>2023-10-26 16:53:52</td>\n      <td>https://jobs.51job.com/beijing/150164515.html?...</td>\n      <td>https://jobs.51job.com/all/coBGBXNQJlU2UEaQFhA...</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>品牌策划</td>\n      <td>['在校生/应届生', '本科', '广告学', '传播学', '五险一金', '免费班车'...</td>\n      <td>北京·通州区</td>\n      <td>5.5-8千</td>\n      <td>在校生/应届生</td>\n      <td>本科</td>\n      <td>家具/家电/玩具/礼品</td>\n      <td>北京闼闼同创工贸</td>\n      <td>民营</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2023-09-22 11:44:37</td>\n      <td>https://jobs.51job.com/beijing-tzq/151081284.h...</td>\n      <td>https://jobs.51job.com/all/coUT8CZwVgADhVNAVuU...</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>品牌策划</td>\n      <td>['1年', '本科', '办公软件', '项目管理', '营销', '品牌推广', '广告...</td>\n      <td>北京·朝阳区</td>\n      <td>7千-1万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>影视/媒体/艺术/文化传播</td>\n      <td>保利影业投资</td>\n      <td>国企</td>\n      <td>150-500人</td>\n      <td>保利文娱科技HR</td>\n      <td>HR</td>\n      <td>2023-11-21 13:26:38</td>\n      <td>https://jobs.51job.com/beijing-cyq/152127685.h...</td>\n      <td>https://jobs.51job.com/all/coUjZcOlU1DzUOaQJhU...</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>撰稿策划</td>\n      <td>['1年', '大专', '五险一金']</td>\n      <td>北京·海淀区</td>\n      <td>8千-1.5万</td>\n      <td>1年</td>\n      <td>大专</td>\n      <td>广告</td>\n      <td>北京创意支点广告</td>\n      <td>民营</td>\n      <td>少于50人</td>\n      <td>admin</td>\n      <td>人事招聘</td>\n      <td>2023-07-18 10:00:45</td>\n      <td>https://jobs.51job.com/beijing-hdq/137789041.h...</td>\n      <td>https://jobs.51job.com/all/coVjZTP141U25UMFAw....</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>创意文案策划</td>\n      <td>['1年', '本科', '传播学', '跨媒体艺术', '策划', '文案', '新媒体'...</td>\n      <td>北京·丰台区</td>\n      <td>9千-1.2万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>北京天策行品牌顾问</td>\n      <td>民营</td>\n      <td>少于50人</td>\n      <td>tcxv7967</td>\n      <td>总经理</td>\n      <td>2023-11-06 16:57:02</td>\n      <td>https://jobs.51job.com/beijing-ftq/132202501.h...</td>\n      <td>https://jobs.51job.com/all/coBGRQNV40VmkCZwZiU...</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>客户执行/AE（北京）</td>\n      <td>['在校生/应届生', '大专', '广告', '公关', '媒体', '五险一金', '餐...</td>\n      <td>北京</td>\n      <td>6-8千·13薪</td>\n      <td>在校生/应届生</td>\n      <td>大专</td>\n      <td>多元化业务集团公司</td>\n      <td>北京天下秀广告</td>\n      <td>民营</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2023-12-01 04:41:23</td>\n      <td>https://jobs.51job.com/beijing/147183336.html?...</td>\n      <td>https://jobs.51job.com/all/coCGlcP1IxVGgFY1Q1U...</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>广告客户经理</td>\n      <td>['1年', '本科', '广告', '营销', '传媒', '互联网', '销售', '客...</td>\n      <td>北京·朝阳区</td>\n      <td>2-4万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>计算机软件</td>\n      <td>上海阿牛信息科技</td>\n      <td>民营</td>\n      <td>150-500人</td>\n      <td>凌女士</td>\n      <td>HR</td>\n      <td>2023-07-06 15:50:13</td>\n      <td>https://jobs.51job.com/beijing-cyq/149118726.h...</td>\n      <td>https://jobs.51job.com/all/coA2JWOwNgUm8CYwVjB...</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>票据录入文员</td>\n      <td>['无需经验', '大专', '数据统计', '统计报表', '校对', '节日福利', '...</td>\n      <td>北京·朝阳区</td>\n      <td>4-5千</td>\n      <td>无需经验</td>\n      <td>大专</td>\n      <td>广告</td>\n      <td>成都上品集创广告策划</td>\n      <td>民营</td>\n      <td>50-150人</td>\n      <td>罗女士</td>\n      <td>HR</td>\n      <td>2023-10-31 09:49:37</td>\n      <td>https://jobs.51job.com/beijing-cyq/151734889.h...</td>\n      <td>https://jobs.51job.com/all/coVDBSP1QyAzQFZQxsA...</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>品牌策划经理</td>\n      <td>['1年', '本科', '市场营销', '商务管理', '五险一金', '绩效奖金']</td>\n      <td>北京·丰台区</td>\n      <td>1-1.5万</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>广告</td>\n      <td>北京天策行品牌顾问</td>\n      <td>民营</td>\n      <td>少于50人</td>\n      <td>tcxv7967</td>\n      <td>总经理</td>\n      <td>2023-11-06 16:56:36</td>\n      <td>https://jobs.51job.com/beijing-ftq/133687600.h...</td>\n      <td>https://jobs.51job.com/all/coBGRQNV40VmkCZwZiU...</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>活动策划执行</td>\n      <td>['1年', '本科', '五险一金', '周末双休', '弹性工作', '带薪年假', '...</td>\n      <td>北京</td>\n      <td>6-9千</td>\n      <td>1年</td>\n      <td>本科</td>\n      <td>互联网/电子商务</td>\n      <td>中国家电网</td>\n      <td>国企</td>\n      <td>50-150人</td>\n      <td>中国家电网</td>\n      <td>人事主管</td>\n      <td>2023-11-07 16:34:33</td>\n      <td>https://jobs.51job.com/beijing/117352119.html?...</td>\n      <td>https://jobs.51job.com/all/coAmcGZlM5DzgPY1QzB...</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_wuyou_job"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "outputs": [],
   "source": [
    "df_wuyou_job = df_wuyou_job.rename(columns={\n",
    "    'jobName':'职位名称',\n",
    "    'jobTags':'职位标签',\n",
    "    'jobAreaString':'岗位地址',\n",
    "    'provideSalaryString':'工资',\n",
    "    'workYearString':'工作经验',\n",
    "    'degreeString':'学历要求',\n",
    "    'industryType1Str':'公司行业',\n",
    "    'companyName':'公司名称',\n",
    "    'companyTypeString':'公司体制',\n",
    "    'companySizeString':'公司规模',\n",
    "    'hrName':'招聘者名称',\n",
    "    'hrPosition':'招聘者职位',\n",
    "    'updateDateTime':'更新时间',\n",
    "    'jobHref':'岗位详情',\n",
    "    'companyHref':'公司官网',\n",
    "})"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "# 尝试进入详情页爬取，抓不到数据，好像是script Ajax动态加载"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "# from requests_html import HTMLSession\n",
    "# session = HTMLSession()"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "# in_headers  = {\n",
    "#     \"Accept\": \"*/*\",\n",
    "#     \"Accept-Encoding\": \"gzip, deflate, br\",\n",
    "#     \"Accept-Language\": \"zh-CN,zh;q=0.9\",\n",
    "#     \"Connection\": \"keep-alive\",\n",
    "#     \"From-Domain\": \"51job_web\",\n",
    "#     \"Host\": \"cupid.51job.com\",\n",
    "#     \"Origin\": \"https://jobs.51job.com\",\n",
    "#     \"Referer\": \"https://jobs.51job.com/\",\n",
    "#     \"Sec-Fetch-Dest\": \"empty\",\n",
    "#     \"Sec-Fetch-Mode\": \"cors\",\n",
    "#     \"Sec-Fetch-Site\": \"same-site\",\n",
    "#     \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36\",\n",
    "#     \"account-id\": \"225393392\",\n",
    "#     \"sec-ch-ua\": \"\\\"Google Chrome\\\";v=\\\"119\\\", \\\"Chromium\\\";v=\\\"119\\\", \\\"Not?A_Brand\\\";v=\\\"24\\\"\",\n",
    "#     \"sec-ch-ua-mobile\": \"?0\",\n",
    "#     \"sec-ch-ua-platform\": \"\\\"Windows\\\"\",\n",
    "#     \"sign\": \"56000c3e79b9c45e675542ecc5f77e5063e568717063ecc5b459e0dd4c00a57c\",\n",
    "#     \"user-token\": \"8631e09ad8ed44cc0933d93833621abf6567e153\",\n",
    "#     \"uuid\": \"df9079b1bea9db9cb298b4eeb9d04e27\"\n",
    "# }"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "# s = session.get(df_wuyou['jobHref'][1],headers=in_headers)\n",
    "# command = s.html.find('div.tmsg')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "# 岗位详情页"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "outputs": [],
   "source": [
    "# import pandas as pd\n",
    "# from requests_html2 import HTMLSession\n",
    "# session = HTMLSession()"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [
    "# df_wuyou['jobHref'][0]"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "is_executing": true
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "outputs": [
    {
     "ename": "IndexError",
     "evalue": "list index out of range",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mIndexError\u001B[0m                                Traceback (most recent call last)",
      "Cell \u001B[1;32mIn[42], line 6\u001B[0m\n\u001B[0;32m      4\u001B[0m contents \u001B[38;5;241m=\u001B[39m s\u001B[38;5;241m.\u001B[39mhtml\u001B[38;5;241m.\u001B[39mfind(\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mdiv.job_msg\u001B[39m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m      5\u001B[0m \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;28mlen\u001B[39m(contents) \u001B[38;5;241m>\u001B[39m\u001B[38;5;241m=\u001B[39m \u001B[38;5;241m0\u001B[39m:\n\u001B[1;32m----> 6\u001B[0m     command \u001B[38;5;241m=\u001B[39m \u001B[43mcontents\u001B[49m\u001B[43m[\u001B[49m\u001B[38;5;241;43m0\u001B[39;49m\u001B[43m]\u001B[49m\u001B[38;5;241m.\u001B[39mtext\n\u001B[0;32m      7\u001B[0m     command \u001B[38;5;241m=\u001B[39m command\u001B[38;5;241m.\u001B[39mreplace(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;130;01m\\n\u001B[39;00m\u001B[38;5;124m\"\u001B[39m,\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124m \u001B[39m\u001B[38;5;124m\"\u001B[39m)\n\u001B[0;32m      8\u001B[0m     技能要求\u001B[38;5;241m.\u001B[39mappend(command)\n",
      "\u001B[1;31mIndexError\u001B[0m: list index out of range"
     ]
    }
   ],
   "source": [
    "# 技能要求 = []\n",
    "# for i in range(len(df_wuyou['jobHref'])):\n",
    "#     s = session.get(df_wuyou['jobHref'][i])\n",
    "#     contents = s.html.find('div.job_msg')\n",
    "#     if len(contents) >= 0:\n",
    "#         command = contents[0].text\n",
    "#         command = command.replace(\"\\n\",\" \")\n",
    "#         技能要求.append(command)\n",
    "#     else:\n",
    "#         command = '无'\n",
    "#         技能要求.append(command)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "# 输出结果"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "outputs": [],
   "source": [
    "df_wuyou_job.to_excel('51job前程无忧-'+citi_name+'-'+key+output_time+'.xlsx')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}
